/*
 Navicat Premium Data Transfer

 Source Server         : gpt生产
 Source Server Type    : MySQL
 Source Server Version : 80024 (8.0.24)
 Source Host           : 43.139.95.94:3306
 Source Schema         : chatgpt

 Target Server Type    : MySQL
 Target Server Version : 80024 (8.0.24)
 File Encoding         : 65001

 Date: 26/04/2023 15:06:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `CRON_EXPRESSION`, `TIME_ZONE_ID`) VALUES ('RenrenScheduler', 'TASK_1645408576650940418', 'DEFAULT', '0 0/2 * * * ? ', 'Asia/Shanghai');
INSERT INTO `qrtz_cron_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `CRON_EXPRESSION`, `TIME_ZONE_ID`) VALUES ('RenrenScheduler', 'TASK_1645445890643083266', 'DEFAULT', '0 0 0 * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint NOT NULL,
  `SCHED_TIME` bigint NOT NULL,
  `PRIORITY` int NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1645408576650940418', 'DEFAULT', NULL, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001876B368BA8787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E001116D5AA61F9A9100274000D4F726465724F76657254696D6574000E3020302F32202A202A202A203F20740000740018E8AEA2E58D95E8B685E697B6E5AE9AE697B6E4BBBBE58AA1737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E00120000000171007E001071007E00137800);
INSERT INTO `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1645445890643083266', 'DEFAULT', NULL, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001876BBE4B04787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E001116D5CC51D0E8400274000F557365725649504D7367436F756E7474000C3020302030202A202A203F2074000074002DE6AF8FE697A5E5878CE699A8E4B8BAE4BC9AE59198E794A8E688B7E5A29EE58AA0E68F90E997AEE69DA1E695B0737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E00120000000171007E001071007E00137800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint NOT NULL,
  `CHECKIN_INTERVAL` bigint NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES ('RenrenScheduler', 'DESKTOP-6S0LLII1682426096031', 1682492812106, 15000);
INSERT INTO `qrtz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES ('RenrenScheduler', 'VM-12-6-centos1682426387062', 1682492813884, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint NOT NULL,
  `REPEAT_INTERVAL` bigint NOT NULL,
  `TIMES_TRIGGERED` bigint NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int DEFAULT NULL,
  `INT_PROP_2` int DEFAULT NULL,
  `LONG_PROP_1` bigint DEFAULT NULL,
  `LONG_PROP_2` bigint DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint DEFAULT NULL,
  `PREV_FIRE_TIME` bigint DEFAULT NULL,
  `PRIORITY` int DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint NOT NULL,
  `END_TIME` bigint DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1645408576650940418', 'DEFAULT', 'TASK_1645408576650940418', 'DEFAULT', NULL, 1682492880000, 1682492760000, 5, 'WAITING', 'CRON', 1681130949000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001876B368D70787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E001116D5AA61F9A9100274000D4F726465724F76657254696D6574000E3020302F32202A202A202A203F20740000740018E8AEA2E58D95E8B685E697B6E5AE9AE697B6E4BBBBE58AA1737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000017371007E000F7708000001876B368D70787371007E00110ECF9F6107B456017800);
INSERT INTO `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `NEXT_FIRE_TIME`, `PREV_FIRE_TIME`, `PRIORITY`, `TRIGGER_STATE`, `TRIGGER_TYPE`, `START_TIME`, `END_TIME`, `CALENDAR_NAME`, `MISFIRE_INSTR`, `JOB_DATA`) VALUES ('RenrenScheduler', 'TASK_1645445890643083266', 'DEFAULT', 'TASK_1645445890643083266', 'DEFAULT', NULL, 1681142400000, -1, 5, 'PAUSED', 'CRON', 1681139845000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001876BBE4B70787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E001116D5CC51D0E8400274000F557365725649504D7367436F756E7474000B3020302030202A202A203F74000074002DE6AF8FE697A5E5878CE699A8E4B8BAE4BC9AE59198E794A8E688B7E5A29EE58AA0E68F90E997AEE69DA1E695B0737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F77080000018798966D80787371007E00110ECF9F6107B456017800);
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `id` bigint NOT NULL COMMENT 'id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint unsigned DEFAULT NULL COMMENT '任务状态  0：暂停  1：正常',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` (`id`, `bean_name`, `params`, `cron_expression`, `status`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645408576650940418, 'OrderOverTime', '', '0 0/2 * * * ? ', 1, '订单超时定时任务', 1067246875800000001, '2023-04-10 20:49:10', 1067246875800000001, '2023-04-10 20:49:10');
INSERT INTO `schedule_job` (`id`, `bean_name`, `params`, `cron_expression`, `status`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645445890643083266, 'UserVIPMsgCount', '', '0 0 0 * * ?', 0, '每日凌晨为会员用户增加提问条数', 1067246875800000001, '2023-04-10 23:17:26', 1067246875800000001, '2023-04-19 16:16:48');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `id` bigint NOT NULL COMMENT 'id',
  `job_id` bigint NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint unsigned NOT NULL COMMENT '任务状态    0：失败    1：成功',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_job_id` (`job_id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------


-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint NOT NULL COMMENT 'id',
  `pid` bigint DEFAULT NULL COMMENT '上级ID',
  `pids` varchar(500) DEFAULT NULL COMMENT '所有上级ID，用逗号分开',
  `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000062, 1067246875800000063, '1067246875800000066,1067246875800000063', '技术部', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000063, 1067246875800000066, '1067246875800000066', '长沙分公司', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000064, 1067246875800000066, '1067246875800000066', '上海分公司', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000065, 1067246875800000064, '1067246875800000066,1067246875800000064', '市场部', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000066, 0, '0', '人人开源集团', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000067, 1067246875800000064, '1067246875800000066,1067246875800000064', '销售部', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dept` (`id`, `pid`, `pids`, `name`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000068, 1067246875800000063, '1067246875800000066,1067246875800000063', '产品部', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `id` bigint NOT NULL COMMENT 'id',
  `dict_type_id` bigint NOT NULL COMMENT '字典类型ID',
  `dict_label` varchar(255) NOT NULL COMMENT '字典标签',
  `dict_value` varchar(255) DEFAULT NULL COMMENT '字典值',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_dict_type_value` (`dict_type_id`,`dict_value`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061112075464705, 1160061077912858625, '男', '0', '', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061146967879681, 1160061077912858625, '女', '1', '', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061190127267841, 1160061077912858625, '保密', '2', '', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814069634195457, 1225813644059140097, '公告', '0', '', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814107559092225, 1225813644059140097, '会议', '1', '', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_data` (`id`, `dict_type_id`, `dict_label`, `dict_value`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225814271879340034, 1225813644059140097, '其他', '2', '', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` bigint NOT NULL COMMENT 'id',
  `dict_type` varchar(100) NOT NULL COMMENT '字典类型',
  `dict_name` varchar(255) NOT NULL COMMENT '字典名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1160061077912858625, 'gender', '性别', '', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_dict_type` (`id`, `dict_type`, `dict_name`, `remark`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1225813644059140097, 'notice_type', '站内通知-类型', '', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
COMMIT;

-- ----------------------------
-- Table structure for sys_log_error
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_error`;
CREATE TABLE `sys_log_error` (
  `id` bigint NOT NULL COMMENT 'id',
  `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式',
  `request_params` text COMMENT '请求参数',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `error_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '异常信息',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='异常日志';

-- ----------------------------
-- Records of sys_log_error
-- ----------------------------


-- ----------------------------
-- Table structure for sys_log_login
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_login`;
CREATE TABLE `sys_log_login` (
  `id` bigint NOT NULL COMMENT 'id',
  `operation` tinyint unsigned DEFAULT NULL COMMENT '用户操作   0：用户登录   1：用户退出',
  `status` tinyint unsigned NOT NULL COMMENT '状态  0：失败    1：成功    2：账号已锁定',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='登录日志';

-- ----------------------------
-- Records of sys_log_login
-- ----------------------------

-- ----------------------------
-- Table structure for sys_log_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_operation`;
CREATE TABLE `sys_log_operation` (
  `id` bigint NOT NULL COMMENT 'id',
  `operation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户操作',
  `request_uri` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方式',
  `request_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `request_time` int unsigned NOT NULL COMMENT '请求时长(毫秒)',
  `user_agent` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作IP',
  `status` tinyint unsigned NOT NULL COMMENT '状态  0：失败   1：成功',
  `creator_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='操作日志';

-- ----------------------------
-- Records of sys_log_operation
-- ----------------------------


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL COMMENT 'id',
  `pid` bigint DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `name` varchar(200) DEFAULT NULL COMMENT '名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)',
  `menu_type` tinyint unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `sort` int DEFAULT NULL COMMENT '排序',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000002, 0, '权限管理', NULL, NULL, 0, 'icon-safetycertificate', 998, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-21 21:37:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000003, 1067246875800000055, '新增', NULL, 'sys:user:save,sys:dept:list,sys:role:list', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000004, 1067246875800000055, '修改', NULL, 'sys:user:update,sys:dept:list,sys:role:list', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000005, 1067246875800000055, '删除', NULL, 'sys:user:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000006, 1067246875800000055, '导出', NULL, 'sys:user:export', 1, NULL, 4, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000007, 1067246875800000002, '角色管理', 'sys/role', NULL, 0, 'icon-team', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000008, 1067246875800000007, '查看', NULL, 'sys:role:page,sys:role:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000009, 1067246875800000007, '新增', NULL, 'sys:role:save,sys:menu:select,sys:dept:list', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000010, 1067246875800000007, '修改', NULL, 'sys:role:update,sys:menu:select,sys:dept:list', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000011, 1067246875800000007, '删除', NULL, 'sys:role:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000012, 1067246875800000002, '部门管理', 'sys/dept', NULL, 0, 'icon-apartment', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000014, 1067246875800000012, '查看', NULL, 'sys:dept:list,sys:dept:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000015, 1067246875800000012, '新增', NULL, 'sys:dept:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000016, 1067246875800000012, '修改', NULL, 'sys:dept:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000017, 1067246875800000012, '删除', NULL, 'sys:dept:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000025, 1067246875800000035, '菜单管理', 'sys/menu', NULL, 0, 'icon-unorderedlist', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000026, 1067246875800000025, '查看', NULL, 'sys:menu:list,sys:menu:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000027, 1067246875800000025, '新增', NULL, 'sys:menu:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000028, 1067246875800000025, '修改', NULL, 'sys:menu:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000029, 1067246875800000025, '删除', NULL, 'sys:menu:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000030, 1648603030123806721, '定时任务', 'job/schedule', NULL, 0, 'icon-dashboard', 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-19 16:23:00');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000031, 1067246875800000030, '查看', NULL, 'sys:schedule:page,sys:schedule:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000032, 1067246875800000030, '新增', NULL, 'sys:schedule:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000033, 1067246875800000030, '修改', NULL, 'sys:schedule:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000034, 1067246875800000030, '删除', NULL, 'sys:schedule:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000035, 0, '系统设置', NULL, NULL, 0, 'icon-setting', 999, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-21 21:37:42');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000036, 1067246875800000030, '暂停', NULL, 'sys:schedule:pause', 1, NULL, 4, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000037, 1067246875800000030, '恢复', NULL, 'sys:schedule:resume', 1, NULL, 5, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000038, 1067246875800000030, '立即执行', NULL, 'sys:schedule:run', 1, NULL, 6, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000039, 1067246875800000030, '日志列表', NULL, 'sys:schedule:log', 1, NULL, 7, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000040, 1067246875800000035, '参数管理', 'sys/params', '', 0, 'icon-fileprotect', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000041, 1067246875800000035, '字典管理', 'sys/dict-type', NULL, 0, 'icon-golden-fill', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000042, 1067246875800000041, '查看', NULL, 'sys:dict:page,sys:dict:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000043, 1067246875800000041, '新增', NULL, 'sys:dict:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000044, 1067246875800000041, '修改', NULL, 'sys:dict:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000045, 1067246875800000041, '删除', NULL, 'sys:dict:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000046, 0, '日志管理', NULL, NULL, 0, 'icon-container', 14, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-19 16:19:23');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000047, 1067246875800000035, '文件上传', 'oss/oss', 'sys:oss:all', 0, 'icon-upload', 4, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000048, 1067246875800000046, '登录日志', 'sys/log-login', 'sys:log:login', 0, 'icon-filedone', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000049, 1067246875800000046, '操作日志', 'sys/log-operation', 'sys:log:operation', 0, 'icon-solution', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000050, 1067246875800000046, '异常日志', 'sys/log-error', 'sys:log:error', 0, 'icon-file-exception', 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000051, 1067246875800000053, 'SQL监控', '{{ window.SITE_CONFIG[\"apiURL\"] }}/druid/sql.html', NULL, 0, 'icon-database', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000053, 0, '系统监控', NULL, NULL, 0, 'icon-desktop', 15, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-19 16:19:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000055, 1067246875800000002, '用户管理', 'sys/user', NULL, 0, 'icon-user', 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000056, 1067246875800000055, '查看', NULL, 'sys:user:page,sys:user:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000057, 1067246875800000040, '新增', NULL, 'sys:params:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000058, 1067246875800000040, '导出', NULL, 'sys:params:export', 1, NULL, 4, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000059, 1067246875800000040, '查看', '', 'sys:params:page,sys:params:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000060, 1067246875800000040, '修改', NULL, 'sys:params:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000061, 1067246875800000040, '删除', '', 'sys:params:delete', 1, '', 3, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1156748733921165314, 1067246875800000053, '接口文档', '{{ window.SITE_CONFIG[\"apiURL\"] }}/doc.html', '', 0, 'icon-file-word', 1, 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644238165919162369, 0, '用户管理', '', '', 0, 'icon-smile', 1, 1067246875800000001, '2023-04-07 15:18:22', 1067246875800000001, '2023-04-21 21:38:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644242578103152641, 0, '商品管理', '', '', 0, 'icon-googleplus-circle-f', 4, 1067246875800000001, '2023-04-07 15:35:54', 1067246875800000001, '2023-04-19 16:19:42');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634370, 1644238165919162369, '用户表', 'tbUser/user', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:51:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634371, 1644257328328634370, '查看', NULL, 'demo:user:page,demo:user:info', 1, NULL, 0, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:37:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634372, 1644257328328634370, '新增', NULL, 'demo:user:save', 1, NULL, 1, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:37:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634373, 1644257328328634370, '修改', NULL, 'demo:user:update', 1, NULL, 2, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:37:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634374, 1644257328328634370, '删除', NULL, 'demo:user:delete', 1, NULL, 3, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:37:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644257328328634375, 1644257328328634370, '导出', NULL, 'demo:user:export', 1, NULL, 4, 1067246875800000001, '2023-04-07 16:37:38', 1067246875800000001, '2023-04-07 16:37:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338049, 1644242578103152641, '商品列表', 'sys/commodity', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:33:11');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338050, 1644601324014338049, '查看', NULL, 'sys:commodity:page,sys:commodity:info', 1, NULL, 0, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:03:34');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338051, 1644601324014338049, '新增', NULL, 'sys:commodity:save', 1, NULL, 1, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:03:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338052, 1644601324014338049, '修改', NULL, 'sys:commodity:update', 1, NULL, 2, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:03:58');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338053, 1644601324014338049, '删除', NULL, 'sys:commodity:delete', 1, NULL, 3, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:04:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644601324014338054, 1644601324014338049, '导出', NULL, 'sys:commodity:export', 1, NULL, 4, 1067246875800000001, '2023-04-08 15:57:01', 1067246875800000001, '2023-04-08 16:04:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183426, 1644971136548601857, '充值订单', 'sys/order', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-09 14:05:13', 1067246875800000001, '2023-04-10 15:32:57');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183427, 1644943632094183426, '查看', NULL, 'sys:order:page,sys:order:info', 1, NULL, 0, 1067246875800000001, '2023-04-09 14:05:13', 1067246875800000001, '2023-04-09 14:05:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183428, 1644943632094183426, '新增', NULL, 'sys:order:save', 1, NULL, 1, 1067246875800000001, '2023-04-09 14:05:13', 1067246875800000001, '2023-04-09 14:05:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183429, 1644943632094183426, '修改', NULL, 'sys:order:update', 1, NULL, 2, 1067246875800000001, '2023-04-09 14:05:14', 1067246875800000001, '2023-04-09 14:05:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183430, 1644943632094183426, '删除', NULL, 'sys:order:delete', 1, NULL, 3, 1067246875800000001, '2023-04-09 14:05:14', 1067246875800000001, '2023-04-09 14:05:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644943632094183431, 1644943632094183426, '导出', NULL, 'sys:order:export', 1, NULL, 4, 1067246875800000001, '2023-04-09 14:05:14', 1067246875800000001, '2023-04-09 14:05:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915522, 1644971136548601857, '问答次数流水', 'speciesList/specieslist', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-09 15:44:46', 1067246875800000001, '2023-04-09 15:51:35');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915523, 1644968773351915522, '查看', NULL, 'speciesList:specieslist:page,speciesList:specieslist:info', 1, NULL, 0, 1067246875800000001, '2023-04-09 15:44:46', 1067246875800000001, '2023-04-09 15:44:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915524, 1644968773351915522, '新增', NULL, 'speciesList:specieslist:save', 1, NULL, 1, 1067246875800000001, '2023-04-09 15:44:46', 1067246875800000001, '2023-04-09 15:44:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915525, 1644968773351915522, '修改', NULL, 'speciesList:specieslist:update', 1, NULL, 2, 1067246875800000001, '2023-04-09 15:44:46', 1067246875800000001, '2023-04-09 15:44:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915526, 1644968773351915522, '删除', NULL, 'speciesList:specieslist:delete', 1, NULL, 3, 1067246875800000001, '2023-04-09 15:44:47', 1067246875800000001, '2023-04-09 15:44:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644968773351915527, 1644968773351915522, '导出', NULL, 'speciesList:specieslist:export', 1, NULL, 4, 1067246875800000001, '2023-04-09 15:44:47', 1067246875800000001, '2023-04-09 15:44:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971136548601857, 0, '订单流水', '', '', 0, 'icon-wallet', 10, 1067246875800000001, '2023-04-09 15:50:56', 1067246875800000001, '2023-04-19 16:21:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277825, 1644976616480763906, '支付配置', 'sys/payconfig', NULL, 0, 'icon-edit-square', 0, 1067246875800000001, '2023-04-09 15:55:49', 1067246875800000001, '2023-04-19 14:03:18');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277826, 1644971206195277825, '查看', NULL, 'sys:payconfig:page,sys:payconfig:info', 1, NULL, 0, 1067246875800000001, '2023-04-09 15:55:49', 1067246875800000001, '2023-04-09 15:55:49');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277827, 1644971206195277825, '新增', NULL, 'sys:payconfig:save', 1, NULL, 1, 1067246875800000001, '2023-04-09 15:55:49', 1067246875800000001, '2023-04-09 15:55:49');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277828, 1644971206195277825, '修改', NULL, 'sys:payconfig:update', 1, NULL, 2, 1067246875800000001, '2023-04-09 15:55:50', 1067246875800000001, '2023-04-09 15:55:50');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277829, 1644971206195277825, '删除', NULL, 'sys:payconfig:delete', 1, NULL, 3, 1067246875800000001, '2023-04-09 15:55:50', 1067246875800000001, '2023-04-09 15:55:50');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644971206195277830, 1644971206195277825, '导出', NULL, 'sys:payconfig:export', 1, NULL, 4, 1067246875800000001, '2023-04-09 15:55:50', 1067246875800000001, '2023-04-09 15:55:50');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644976616480763906, 0, '支付配置', '', '', 0, 'icon-YUAN', 6, 1067246875800000001, '2023-04-09 16:12:42', 1067246875800000001, '2023-04-19 16:20:08');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987649, 1645018501173366785, 'AI角色模型', 'aimodel/aimodel', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:59:27');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987650, 1645007532600987649, '查看', NULL, 'aimodel:aimodel:page,aimodel:aimodel:info', 1, NULL, 0, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:42:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987651, 1645007532600987649, '新增', NULL, 'aimodel:aimodel:save', 1, NULL, 1, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:42:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987652, 1645007532600987649, '修改', NULL, 'aimodel:aimodel:update', 1, NULL, 2, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:42:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987653, 1645007532600987649, '删除', NULL, 'aimodel:aimodel:delete', 1, NULL, 3, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:42:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645007532600987654, 1645007532600987649, '导出', NULL, 'aimodel:aimodel:export', 1, NULL, 4, 1067246875800000001, '2023-04-09 18:42:40', 1067246875800000001, '2023-04-09 18:42:40');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645018501173366785, 0, '模型问题管理', '', '', 0, 'icon-layout', 5, 1067246875800000001, '2023-04-09 18:59:08', 1067246875800000001, '2023-04-19 16:19:59');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504258, 1645018501173366785, '提问模板分类', 'tmplCategory/tmplcategory', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-10 10:36:38', 1067246875800000001, '2023-04-10 10:57:06');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504259, 1645254305009504258, '查看', NULL, 'tmplCategory:tmplcategory:page,tmplCategory:tmplcategory:info', 1, NULL, 0, 1067246875800000001, '2023-04-10 10:36:38', 1067246875800000001, '2023-04-10 10:36:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504260, 1645254305009504258, '新增', NULL, 'tmplCategory:tmplcategory:save', 1, NULL, 1, 1067246875800000001, '2023-04-10 10:36:38', 1067246875800000001, '2023-04-10 10:36:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504261, 1645254305009504258, '修改', NULL, 'tmplCategory:tmplcategory:update', 1, NULL, 2, 1067246875800000001, '2023-04-10 10:36:39', 1067246875800000001, '2023-04-10 10:36:39');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504262, 1645254305009504258, '删除', NULL, 'tmplCategory:tmplcategory:delete', 1, NULL, 3, 1067246875800000001, '2023-04-10 10:36:39', 1067246875800000001, '2023-04-10 10:36:39');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645254305009504263, 1645254305009504258, '导出', NULL, 'tmplCategory:tmplcategory:export', 1, NULL, 4, 1067246875800000001, '2023-04-10 10:36:39', 1067246875800000001, '2023-04-10 10:36:39');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247617, 1645018501173366785, '提问模板问题', 'tmplQs/tmplqs', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:57:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247618, 1645256079179247617, '查看', NULL, 'tmplQs:tmplqs:page,tmplQs:tmplqs:info', 1, NULL, 0, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:43:45');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247619, 1645256079179247617, '新增', NULL, 'tmplQs:tmplqs:save', 1, NULL, 1, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:43:45');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247620, 1645256079179247617, '修改', NULL, 'tmplQs:tmplqs:update', 1, NULL, 2, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:43:45');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247621, 1645256079179247617, '删除', NULL, 'tmplQs:tmplqs:delete', 1, NULL, 3, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:43:45');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645256079179247622, 1645256079179247617, '导出', NULL, 'tmplQs:tmplqs:export', 1, NULL, 4, 1067246875800000001, '2023-04-10 10:43:45', 1067246875800000001, '2023-04-10 10:43:45');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415553, 1645018501173366785, '热门问题管理', 'hotQs/hotqs', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-10 10:49:13', 1067246875800000001, '2023-04-10 10:57:22');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415554, 1645257493259415553, '查看', NULL, 'hotQs:hotqs:page,hotQs:hotqs:info', 1, NULL, 0, 1067246875800000001, '2023-04-10 10:49:13', 1067246875800000001, '2023-04-10 10:49:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415555, 1645257493259415553, '新增', NULL, 'hotQs:hotqs:save', 1, NULL, 1, 1067246875800000001, '2023-04-10 10:49:13', 1067246875800000001, '2023-04-10 10:49:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415556, 1645257493259415553, '修改', NULL, 'hotQs:hotqs:update', 1, NULL, 2, 1067246875800000001, '2023-04-10 10:49:14', 1067246875800000001, '2023-04-10 10:49:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415557, 1645257493259415553, '删除', NULL, 'hotQs:hotqs:delete', 1, NULL, 3, 1067246875800000001, '2023-04-10 10:49:14', 1067246875800000001, '2023-04-10 10:49:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645257493259415558, 1645257493259415553, '导出', NULL, 'hotQs:hotqs:export', 1, NULL, 4, 1067246875800000001, '2023-04-10 10:49:14', 1067246875800000001, '2023-04-10 10:49:14');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875841, 1645312108150280193, '问答记录', 'questionAnswer/questionanswer', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-10 13:59:12', 1067246875800000001, '2023-04-10 14:26:07');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875842, 1645305310515875841, '查看', NULL, 'questionAnswer:questionanswer:page,questionAnswer:questionanswer:info', 1, NULL, 0, 1067246875800000001, '2023-04-10 13:59:13', 1067246875800000001, '2023-04-10 13:59:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875843, 1645305310515875841, '新增', NULL, 'questionAnswer:questionanswer:save', 1, NULL, 1, 1067246875800000001, '2023-04-10 13:59:13', 1067246875800000001, '2023-04-10 13:59:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875844, 1645305310515875841, '修改', NULL, 'questionAnswer:questionanswer:update', 1, NULL, 2, 1067246875800000001, '2023-04-10 13:59:13', 1067246875800000001, '2023-04-10 13:59:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875845, 1645305310515875841, '删除', NULL, 'questionAnswer:questionanswer:delete', 1, NULL, 3, 1067246875800000001, '2023-04-10 13:59:13', 1067246875800000001, '2023-04-10 13:59:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645305310515875846, 1645305310515875841, '导出', NULL, 'questionAnswer:questionanswer:export', 1, NULL, 4, 1067246875800000001, '2023-04-10 13:59:13', 1067246875800000001, '2023-04-10 13:59:13');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645312108150280193, 0, '问答记录', '', '', 0, 'icon-reloadtime', 8, 1067246875800000001, '2023-04-10 14:25:50', 1067246875800000001, '2023-04-19 16:20:34');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995842, 1644971136548601857, '邀请返利', 'sys/inviterebate', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-10 15:07:48', 1067246875800000001, '2023-04-10 15:12:51');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995843, 1645314684984995842, '查看', NULL, 'sys:inviterebate:page,sys:inviterebate:info', 1, NULL, 0, 1067246875800000001, '2023-04-10 15:07:48', 1067246875800000001, '2023-04-10 15:07:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995844, 1645314684984995842, '新增', NULL, 'sys:inviterebate:save', 1, NULL, 1, 1067246875800000001, '2023-04-10 15:07:48', 1067246875800000001, '2023-04-10 15:07:48');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995845, 1645314684984995842, '修改', NULL, 'sys:inviterebate:update', 1, NULL, 2, 1067246875800000001, '2023-04-10 15:07:49', 1067246875800000001, '2023-04-10 15:07:49');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995846, 1645314684984995842, '删除', NULL, 'sys:inviterebate:delete', 1, NULL, 3, 1067246875800000001, '2023-04-10 15:07:49', 1067246875800000001, '2023-04-10 15:07:49');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645314684984995847, 1645314684984995842, '导出', NULL, 'sys:inviterebate:export', 1, NULL, 4, 1067246875800000001, '2023-04-10 15:07:49', 1067246875800000001, '2023-04-10 15:07:49');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878593, 1646060999791509506, 'KEY管理', 'gptKey/gptkey', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 16:02:16');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878594, 1646059879520878593, '查看', NULL, 'gptKey:gptkey:page,gptKey:gptkey:info', 1, NULL, 0, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 15:57:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878595, 1646059879520878593, '新增', NULL, 'gptKey:gptkey:save', 1, NULL, 1, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 15:57:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878596, 1646059879520878593, '修改', NULL, 'gptKey:gptkey:update', 1, NULL, 2, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 15:57:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878597, 1646059879520878593, '删除', NULL, 'gptKey:gptkey:delete', 1, NULL, 3, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 15:57:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646059879520878598, 1646059879520878593, '导出', NULL, 'gptKey:gptkey:export', 1, NULL, 4, 1067246875800000001, '2023-04-12 15:57:38', 1067246875800000001, '2023-04-12 15:57:38');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646060999791509506, 0, 'GPT管理', '', '', 0, 'icon-info-circle', 9, 1067246875800000001, '2023-04-12 16:01:39', 1067246875800000001, '2023-04-19 16:20:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249794, 1646403878167552001, '提现列表', 'sys/withdrawal', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-18 23:33:46');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249795, 1646399831033249794, '查看', NULL, 'sys:withdrawal:page,sys:withdrawal:info', 1, NULL, 0, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-13 14:28:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249796, 1646399831033249794, '新增', NULL, 'sys:withdrawal:save', 1, NULL, 1, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-13 14:28:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249797, 1646399831033249794, '修改', NULL, 'sys:withdrawal:update', 1, NULL, 2, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-13 14:28:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249798, 1646399831033249794, '删除', NULL, 'sys:withdrawal:delete', 1, NULL, 3, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-13 14:28:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646399831033249799, 1646399831033249794, '导出', NULL, 'sys:withdrawal:export', 1, NULL, 4, 1067246875800000001, '2023-04-13 14:28:47', 1067246875800000001, '2023-04-13 14:28:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646403878167552001, 0, '提现管理', '', '', 0, 'icon-transaction', 7, 1067246875800000001, '2023-04-13 14:44:08', 1067246875800000001, '2023-04-19 16:20:19');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1648603030123806721, 0, '定时任务', '', '', 0, 'icon-reloadtime', 11, 1067246875800000001, '2023-04-19 16:22:47', 1067246875800000001, '2023-04-19 16:22:47');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032257, 1650805595072139266, '海报设置表', 'poster/poster', NULL, 0, 'icon-desktop', 0, 1067246875800000001, '2023-04-25 15:46:29', 1067246875800000001, '2023-04-25 18:15:11');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032258, 1650759769480032257, '查看', NULL, 'poster:poster:page,poster:poster:info', 1, NULL, 0, 1067246875800000001, '2023-04-25 15:46:29', 1067246875800000001, '2023-04-25 15:46:29');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032259, 1650759769480032257, '新增', NULL, 'poster:poster:save', 1, NULL, 1, 1067246875800000001, '2023-04-25 15:46:29', 1067246875800000001, '2023-04-25 15:46:29');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032260, 1650759769480032257, '修改', NULL, 'poster:poster:update', 1, NULL, 2, 1067246875800000001, '2023-04-25 15:46:30', 1067246875800000001, '2023-04-25 15:46:30');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032261, 1650759769480032257, '删除', NULL, 'poster:poster:delete', 1, NULL, 3, 1067246875800000001, '2023-04-25 15:46:30', 1067246875800000001, '2023-04-25 15:46:30');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650759769480032262, 1650759769480032257, '导出', NULL, 'poster:poster:export', 1, NULL, 4, 1067246875800000001, '2023-04-25 15:46:30', 1067246875800000001, '2023-04-25 15:46:30');
INSERT INTO `sys_menu` (`id`, `pid`, `name`, `url`, `permissions`, `menu_type`, `icon`, `sort`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650805595072139266, 0, '海报设置', '', '', 0, 'icon-CI', 0, 1067246875800000001, '2023-04-25 18:14:59', 1067246875800000001, '2023-04-25 20:03:48');
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint NOT NULL COMMENT 'id',
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='文件上传';

-- ----------------------------
-- Records of sys_oss
-- ----------------------------


-- ----------------------------
-- Table structure for sys_params
-- ----------------------------
DROP TABLE IF EXISTS `sys_params`;
CREATE TABLE `sys_params` (
  `id` bigint NOT NULL COMMENT 'id',
  `param_code` varchar(32) DEFAULT NULL COMMENT '参数编码',
  `param_value` varchar(2000) DEFAULT NULL COMMENT '参数值',
  `param_type` tinyint unsigned DEFAULT '1' COMMENT '类型   0：系统参数   1：非系统参数',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_param_code` (`param_code`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数管理';

-- ----------------------------
-- Records of sys_params
-- ----------------------------
BEGIN;
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1067246875800000073, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":2,\"qiniuDomain\":\"http://test.oss.renren.io\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"1234\",\"qiniuSecretKey\":\"1234\",\"qiniuBucketName\":\"renren-oss\",\"aliyunDomain\":\"https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"oss-cn-chengdu.aliyuncs.com\",\"aliyunAccessKeyId\":\"LTAI5tHkYhFReWG464qST8WG\",\"aliyunAccessKeySecret\":\"dEVNJSaIygJUlBdTQcHWpiXCqY82Lr\",\"aliyunBucketName\":\"momoyu-chatgpt\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', 0, '云存储配置信息', 1067246875800000001, '2023-04-07 13:43:19', 1067246875800000001, '2023-04-07 13:43:19');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644929293802946562, 'vip_gift_number', '12', 1, '会员用户每日赠送提问条数', 1067246875800000001, '2023-04-09 13:04:40', 1067246875800000001, '2023-04-09 13:04:40');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644930475015421953, 'invite_rebate_number', '20', 1, '邀请新用户注册上级获得发送条数(新用户注册时获得)', 1067246875800000001, '2023-04-09 13:09:21', 1067246875800000001, '2023-04-09 13:09:21');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644952764469477378, 'app_wx_login_appid', '123', 1, 'app微信快捷登入的APPID', 1067246875800000001, '2023-04-09 14:37:55', 1067246875800000001, '2023-04-09 15:13:49');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644952864474267650, 'app_wx_login_secret', '123', 1, 'app微信快捷登录的秘钥', 1067246875800000001, '2023-04-09 14:38:19', 1067246875800000001, '2023-04-09 15:13:55');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644953043260669954, 'register_msg_count', '10', 1, '刚注册新用户送的提问条数', 1067246875800000001, '2023-04-09 14:39:02', 1067246875800000001, '2023-04-09 14:39:02');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1644979096347738114, 'invite_msg_count', '5', 1, '邀请用户注册奖励条数', 1067246875800000001, '2023-04-09 16:22:33', 1067246875800000001, '2023-04-19 15:53:01');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645970814469865474, 'mini_app_appid', '123', 1, '小程序APPID', 1067246875800000001, '2023-04-12 10:03:17', 1067246875800000001, '2023-04-12 10:03:17');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1645970907935735810, 'mini_app_secret', '123', 1, '小程序秘钥', 1067246875800000001, '2023-04-12 10:03:40', 1067246875800000001, '2023-04-12 10:03:40');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646051600076869634, 'sign_in', '5', 1, '用户每日签到赠送提问条数', 1067246875800000001, '2023-04-12 15:24:18', 1067246875800000001, '2023-04-12 15:24:18');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646070365887893505, 'JG_APP_KEY', '123', 1, '极光短信APPKEY', 1067246875800000001, '2023-04-12 16:38:52', 1067246875800000001, '2023-04-12 16:38:52');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646070703223181314, 'JG_SERCET', '123', 1, '极光短信masterSecret', 1067246875800000001, '2023-04-12 16:40:13', 1067246875800000001, '2023-04-12 16:40:13');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646386640714846209, 'CHAT_GPT_URL', 'http://chatgpt.dzqsm.top/', 1, 'chatgpt的代理地址,不填就会使用官方节点地址', 1067246875800000001, '2023-04-13 13:35:38', 1067246875800000001, '2023-04-13 13:35:38');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646762080548237313, 'service_charge_scale', '0', 1, '提现手续费比例(%)', 1067246875800000001, '2023-04-14 14:27:30', 1067246875800000001, '2023-04-19 15:52:25');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1646762535751856129, 'withdrawal_lowest_quota', '0', 1, '最低提现额度(元)', 1067246875800000001, '2023-04-14 14:29:19', 1067246875800000001, '2023-04-19 15:52:18');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1648669289892491266, 'H5_URL', 'https://ai.momoyucm.top/#/pages/index/index', 1, '项目的H5域名,邀请分享出去就是这个域名', 1067246875800000001, '2023-04-19 20:46:04', 1067246875800000001, '2023-04-25 20:08:42');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1649653599086673922, 'mp_wx_login_appid', '123', 1, '微信公众号APPID', 1067246875800000001, '2023-04-22 13:57:22', 1067246875800000001, '2023-04-22 13:57:22');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1649653702539182081, 'mp_wx_login_secret', '123', 1, '微信公众号秘钥', 1067246875800000001, '2023-04-22 13:57:46', 1067246875800000001, '2023-04-22 13:57:46');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1649738964233453569, 'invite_title', '智能工具箱', 1, '微信公众号/小程序分享的标题', 1067246875800000001, '2023-04-22 19:36:34', 1067246875800000001, '2023-04-22 19:36:34');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1649739142046777345, 'invite_img_url', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230422/85e5463710ba4e85822816522858240e.png', 1, '微信公众号/小程序分享的图片的URL,可在系统设置-&gt;文件上传中上传图片后获得url', 1067246875800000001, '2023-04-22 19:37:17', 1067246875800000001, '2023-04-22 19:38:54');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1649739365867421698, 'invite_summary', '欢迎使用智能工具箱', 1, '微信公众号分享的文字内容', 1067246875800000001, '2023-04-22 19:38:10', 1067246875800000001, '2023-04-22 19:38:10');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650405635981934593, 'invite_poster_url', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230424/b87c2673e12048eb9ac59297421b104b.jpeg', 1, '海报图片的URL,再系统设置,文件上传处上传图片后得到url', 1067246875800000001, '2023-04-24 15:45:41', 1067246875800000001, '2023-04-24 15:45:41');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650801081132875778, 'msg_img_price', '3', 1, '绘画扣除的问答币数量', 1067246875800000001, '2023-04-25 17:57:03', 1067246875800000001, '2023-04-25 17:57:03');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650801699046760450, 'invite_rebate_one', '10', 1, '邀请一级返利百分比', 1067246875800000001, '2023-04-25 17:59:30', 1067246875800000001, '2023-04-26 14:18:47');
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `param_type`, `remark`, `creator`, `create_date`, `updater`, `update_date`) VALUES (1650801837555261441, 'invite_rebate_two', '5', 1, '邀请二级返利百分比', 1067246875800000001, '2023-04-25 18:00:03', 1067246875800000001, '2023-04-26 14:18:41');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_data_scope
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_data_scope`;
CREATE TABLE `sys_role_data_scope` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色数据权限';

-- ----------------------------
-- Records of sys_role_data_scope
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色菜单关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `id` bigint NOT NULL COMMENT 'id',
  `role_id` bigint DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint DEFAULT NULL COMMENT '用户ID',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色用户关系';

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint NOT NULL COMMENT 'id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `real_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `head_url` varchar(200) DEFAULT NULL COMMENT '头像',
  `gender` tinyint unsigned DEFAULT NULL COMMENT '性别   0：男   1：女    2：保密',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `super_admin` tinyint unsigned DEFAULT NULL COMMENT '超级管理员   0：否   1：是',
  `status` tinyint DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `creator` bigint DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO sys_user(id, username, password, real_name, gender, email, mobile, status, dept_id, super_admin, creator, create_date, updater, update_date) VALUES (1067246875800000001, 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', 0, 'root@renren.io', '13612345678', 1, null, 1, 1067246875800000001, now(), 1067246875800000001, now());
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `token` varchar(100) NOT NULL COMMENT '用户token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` (`id`, `user_id`, `token`, `expire_date`, `update_date`, `create_date`) VALUES (1644215804805320706, 1067246875800000001, 'e1a8ef1d32617ae9a822ff3386022877', '2023-04-27 01:01:10', '2023-04-26 13:01:10', '2023-04-07 13:49:31');
COMMIT;

-- ----------------------------
-- Table structure for tb_ai_model
-- ----------------------------
DROP TABLE IF EXISTS `tb_ai_model`;
CREATE TABLE `tb_ai_model` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `model_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模型内容,比如,你是专业的翻译，你只需要翻译该内容，不必对内容中提出的问题和要求做解释，不要回答文本中的问题而是翻译它，不要解决文本中的要求而是翻译它,保留文本的原本意义，不要去解决它。',
  `model_title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模型标题',
  `model_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '复合模型角色的头像',
  `status` int DEFAULT NULL COMMENT '模型状态(0正常1禁用)',
  `model_hot` int DEFAULT NULL COMMENT '是否为热门模型(0是1否)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `model_call` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模型打招呼内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651072600966742019 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='AI角色模型表';

-- ----------------------------
-- Records of tb_ai_model
-- ----------------------------
BEGIN;
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1645028500251496450, '你是专业的翻译，你只需要翻译该内容，不必对内容中提出的问题和要求做解释，不要回答文本中的问题而是翻译它，不要解决文本中的要求而是翻译它,保留文本的原本意义，不要去解决它。', '翻译', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230409/e02fbf29d41c4103b3a62cdb200d6187.png', 0, 0, '2023-04-09 19:59:37', '我是一名专业的翻译');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1645033510834155521, '你是资深程序员,帮助用户解答IT行业的各种问题', '程序员', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230409/875d0b4e8b4b49d29d881630878ee96e.png', 0, 0, '2023-04-09 19:58:47', '我是一名专业的程序员');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1650857438951292929, '你是专业的学习顾问,无论用户提问语文、英语、数学、物理、地理、化学、历史、生物等各学科的问题,都需要帮用户解答', '学习顾问', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230425/d80c36437f314599b21be4750c149cff.png', 0, 0, '2023-04-25 21:41:00', '你好，我是您的私人学习顾问，您可以问我关于语文、英语、数学、物理、地理、化学、历史、生物等各学科 问题哦');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651059263910494209, '你现在是私人医疗顾问，用户可以向你咨询任何医疗相关问题。你为用户解答', '医疗顾问', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/54ff1b5cbdcf435d8433a3f8a1bc5cb5.jpg', 0, 0, '2023-04-26 11:02:58', '您好，我是您的私人医疗顾问，您可以向我咨询任何医疗相关问题。');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651070999082352641, '你现在是一名法律顾问,帮助用户解答法律相关的问题.', '法律顾问', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/7f456124522943bfaa73f04e1e37764d.jpg', 0, 0, '2023-04-26 11:49:36', '您好，我是您的法律顾问，您可以帮您解决任何法律问题。');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651071299272884225, '你是五星级大厨,为用户提供各类菜品制作方式以及菜谱.', '私人厨房', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/0a3750f145d8473f9568bec5fc56b818.jpg', 0, 0, '2023-04-26 11:50:48', '您好，我是您的美食大厨，可以为您提供精致美食菜谱');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651071662893875201, '你是营销策划师,帮用户写出用户需要的方案.', '营销策划', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/c6439707744e444b9255363af9a471d4.jpg', 0, 0, '2023-04-26 11:52:15', '您好，您可以提出您想要的方案，越详细越好。比如:帮我写一个有创意的艺术培训招生营销方案，且足够吸引学生和家长。');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651071830724755458, '你是编剧老师，为用户提供任何主题相关的剧本内容.', '编剧', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/87a7737cfb9844678bc27d28e61c3850.jpg', 0, 0, '2023-04-26 11:52:55', '您好，我将担任您的编剧老师，为您提供任何主题相关的剧本内容');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651072025332072449, '你是说唱歌手，为用户提供想要的歌曲的歌词', '说唱歌手', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/60d3241f2d7b48a4a0587c8bdc190d93.jpg', 0, 0, '2023-04-26 11:53:41', '您好，我是一个说唱歌手，为您提供您想要的歌曲的歌词');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651072200133885954, '你是一名会计师，将为用户针对他想咨询的问题进 行答疑解惑', '会计师', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/15c589c5dce3455d93c95a7e1af1a8cb.jpeg', 0, 0, '2023-04-26 11:54:23', '您好，我是一名会计师，将为您针对您想咨询的问题进 行答疑解惑');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651072313690472449, '你是一名投资顾问，将为用户针对用户想咨询的问题进行答疑解惑', '投资顾问', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/fb74802456124243a043abfc6df0806e.jpg', 0, 0, '2023-04-26 11:54:50', '您好，我是一名投资顾问，将为您针对您想咨询的问题进行答疑解惑');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651072475422834689, '你是一名室内装修师，可以为用户提供装修装饰相关的建议。', '室内装修师', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/b33ff3c1ed6645eeb29196887291f28c.jpeg', 0, 0, '2023-04-26 11:55:28', '您好，我是一名室内装修师，可以为您提供装修装饰相关的建议。');
INSERT INTO `tb_ai_model` (`id`, `model_content`, `model_title`, `model_img`, `status`, `model_hot`, `create_time`, `model_call`) VALUES (1651072600966742018, '你是私人造型师，可以为用户提供关于造型服装等方面时尚方面的建议', '个人造型师', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/00ab929841764735b3a67b9a40667789.jpeg', 0, 0, '2023-04-26 11:55:58', '您好，我是您的私人造型师，可以为您提供关于造型服装等方面时尚方面的建议');
COMMIT;

-- ----------------------------
-- Table structure for tb_commodity
-- ----------------------------
DROP TABLE IF EXISTS `tb_commodity`;
CREATE TABLE `tb_commodity` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '商品表ID(主键)',
  `commodity_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称',
  `commodity_price` decimal(20,2) NOT NULL COMMENT '商品价格',
  `commodity_spec` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品规格(条数/天数)',
  `type` int NOT NULL COMMENT '商品类型(1:购买条数  2:购买VIP)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品备注',
  `status` int DEFAULT NULL COMMENT '是否开启(1:是  2:否)',
  `time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649784474185072643 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品表';

-- ----------------------------
-- Records of tb_commodity
-- ----------------------------
BEGIN;
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644617512184770562, '10 个', 2.00, '10', 1, '2元10次提问次数', 1, '2023-04-07 13:43:19');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644618531195121665, '30 个', 5.00, '30', 1, '5元30次提问', 1, '2023-04-07 13:43:19');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644619008829919234, '80 个', 10.00, '80', 1, '10元80次提问', 1, '2023-04-08 16:31:42');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644656758702510082, '120 个', 15.00, '120', 1, '15元120次提问', 1, '2023-04-08 19:01:42');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644657517783453697, '会员周卡🔥限时优惠🔥', 9.90, '7', 2, '限时优惠9.9', 1, '2023-04-08 19:04:43');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1644658067035951105, '会员月卡', 29.00, '30', 2, '18元31天会员', 1, '2023-04-08 19:06:54');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1649784287291080706, '会员季卡', 59.00, '90', 2, '38元4个月会员', 1, '2023-04-22 22:36:40');
INSERT INTO `tb_commodity` (`id`, `commodity_name`, `commodity_price`, `commodity_spec`, `type`, `remark`, `status`, `time`) VALUES (1649784474185072642, '会员年卡', 108.00, '365', 2, '88元一年会员', 1, '2023-04-22 22:37:25');
COMMIT;

-- ----------------------------
-- Table structure for tb_gpt_key
-- ----------------------------
DROP TABLE IF EXISTS `tb_gpt_key`;
CREATE TABLE `tb_gpt_key` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `api_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'GPT的KEY',
  `status` int DEFAULT NULL COMMENT '状态(0启用1关闭)',
  `remarks` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651109473139343363 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='KEY管理';

-- ----------------------------
-- Records of tb_gpt_key
-- ----------------------------


-- ----------------------------
-- Table structure for tb_hot_qs
-- ----------------------------
DROP TABLE IF EXISTS `tb_hot_qs`;
CREATE TABLE `tb_hot_qs` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `hot_qs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '热门问题内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1648671118101524483 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='热门问题表';

-- ----------------------------
-- Records of tb_hot_qs
-- ----------------------------
BEGIN;
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1645260236025638914, '诸多利好政策的刺激下，2023年在中国会是买房的好时机吗？', NULL);
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648670841843691521, '销售一部手机的文案', '2023-04-19 20:52:14');
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648670895904075778, '什么是BMI指数?', '2023-04-19 20:52:27');
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648670948819415041, '为玩具店写一个标语', '2023-04-19 20:52:40');
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648671003072737281, '推荐一些轻音乐', '2023-04-19 20:52:53');
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648671058047479810, '为西游记写一个番外故事', '2023-04-19 20:53:06');
INSERT INTO `tb_hot_qs` (`id`, `hot_qs`, `create_time`) VALUES (1648671118101524482, '推荐三本经济学入门书籍', '2023-04-19 20:53:20');
COMMIT;

-- ----------------------------
-- Table structure for tb_invite_rebate
-- ----------------------------
DROP TABLE IF EXISTS `tb_invite_rebate`;
CREATE TABLE `tb_invite_rebate` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '邀请返利ID(主键ID)',
  `user_id` bigint NOT NULL COMMENT '获得返利用户ID',
  `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '获得返利用户名称',
  `scale` decimal(20,2) DEFAULT NULL COMMENT '返利比例',
  `money` decimal(20,2) DEFAULT NULL COMMENT '订单充值金额',
  `acquire_money` decimal(20,2) DEFAULT NULL COMMENT '获得金额',
  `front_vacancies` decimal(20,2) DEFAULT NULL COMMENT '返利前余额',
  `behind_vacancies` decimal(20,2) DEFAULT NULL COMMENT '获取佣金后余额(当前余额)',
  `below_rank` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下级级别(下一级,下二级)',
  `below_user_id` bigint DEFAULT NULL COMMENT '下级用户ID',
  `below_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下级用户名称',
  `order_id` bigint DEFAULT NULL COMMENT '关联订单ID',
  `time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649814545485086723 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='邀请返利表';

-- ----------------------------
-- Records of tb_invite_rebate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '订单表ID(主键ID)',
  `user_id` bigint NOT NULL COMMENT '充值用户ID',
  `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '充值用户昵称',
  `commodity_id` bigint NOT NULL COMMENT '充值商品ID',
  `commodity_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '充值商品名称',
  `commodity_type` int NOT NULL COMMENT '充值商品类型(1:购买条数  2:购买VIP)',
  `pay_id` bigint NOT NULL COMMENT '充值通道ID',
  `pay_type` int NOT NULL COMMENT '充值通道类型(1:支付宝  2:微信公众号  3:微信H5  4:微信小程序)',
  `order_code` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台订单号',
  `trilateral_code` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '三方支付订单号(查账订单号)',
  `recharge_amount` decimal(20,2) NOT NULL COMMENT '充值金额(元)',
  `order_type` int NOT NULL COMMENT '订单支付状态(0:订单创建  1:支付中  2:支付成功 3:支付失败  4:订单超时)',
  `found_time` datetime NOT NULL COMMENT '订单创建时间',
  `operate_time` datetime DEFAULT NULL COMMENT '订单操作时间(订单状态 创建-支付中-支付成功时间修改)',
  `over_time` datetime DEFAULT NULL COMMENT '订单超时时间(支付订单一般超过五分钟没有支付为订单超时  订单状态变为4)',
  `commission` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上级返佣金额(邀请返利金额 以逗号分隔 前为一级用户返利  后为二级用户返利)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651106981584347139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单表';

-- ----------------------------
-- Records of tb_order
-- ----------------------------
BEGIN;
INSERT INTO `tb_order` (`id`, `user_id`, `user_name`, `commodity_id`, `commodity_name`, `commodity_type`, `pay_id`, `pay_type`, `order_code`, `trilateral_code`, `recharge_amount`, `order_type`, `found_time`, `operate_time`, `over_time`, `commission`) VALUES (1650840346357161985, 1650837116290097154, '远离的灯红酒绿', 1644657517783453697, '会员周卡', 2, 1645018276866605057, 2, 'WX_GZH_PAY_202304252033036952690', '', 6.00, 3, '2023-04-25 20:33:04', '2023-04-25 20:33:04', '2023-04-25 21:03:04', NULL);
INSERT INTO `tb_order` (`id`, `user_id`, `user_name`, `commodity_id`, `commodity_name`, `commodity_type`, `pay_id`, `pay_type`, `order_code`, `trilateral_code`, `recharge_amount`, `order_type`, `found_time`, `operate_time`, `over_time`, `commission`) VALUES (1650897393941520386, 1650852058493902850, '用户9603', 1644657517783453697, '会员周卡🔥限时优惠🔥', 2, 1644977227079151617, 1, 'ALI_H5_PAY_202304260019458631180', '', 9.90, 3, '2023-04-26 00:19:46', '2023-04-26 00:19:46', '2023-04-26 00:49:45', NULL);
INSERT INTO `tb_order` (`id`, `user_id`, `user_name`, `commodity_id`, `commodity_name`, `commodity_type`, `pay_id`, `pay_type`, `order_code`, `trilateral_code`, `recharge_amount`, `order_type`, `found_time`, `operate_time`, `over_time`, `commission`) VALUES (1651106922708901889, 1651105233989836801, 'Immortal', 1649784474185072642, '会员年卡', 2, 1645018276866605057, 2, 'WX_GZH_PAY_202304261412203955500', '', 108.00, 3, '2023-04-26 14:12:21', '2023-04-26 14:12:21', '2023-04-26 14:42:21', NULL);
INSERT INTO `tb_order` (`id`, `user_id`, `user_name`, `commodity_id`, `commodity_name`, `commodity_type`, `pay_id`, `pay_type`, `order_code`, `trilateral_code`, `recharge_amount`, `order_type`, `found_time`, `operate_time`, `over_time`, `commission`) VALUES (1651106981584347138, 1651105233989836801, 'Immortal', 1644658067035951105, '会员月卡', 2, 1645018276866605057, 2, 'WX_GZH_PAY_202304261412347975950', '', 29.00, 3, '2023-04-26 14:12:35', '2023-04-26 14:12:35', '2023-04-26 14:42:35', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_pay_config
-- ----------------------------
DROP TABLE IF EXISTS `tb_pay_config`;
CREATE TABLE `tb_pay_config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '支付通道ID(主键ID)',
  `app_appid_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信小程序/微信公众号APPID(JSAPI支付专属)  参数配置对应',
  `app_secret_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信小程序/微信公众号密钥(JSAPI支付专属)  参数配置对应',
  `app_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户APPID',
  `merchant_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商户号',
  `app_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商户密钥',
  `private_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商户私钥',
  `public_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商户公钥',
  `pay_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付网关URL',
  `pay_url_montage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付网关URL拼接字段(该字段允许为NULL 应对某些支付需要单独拼接URL字符串)',
  `notify_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付回调地址',
  `return_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付完成后同步跳转地址',
  `merchants_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商户名称',
  `pay_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付公司名称(例:支付宝,微信,汇付等)',
  `type` int DEFAULT NULL COMMENT '支付类型(1:支付宝  2:微信公众号  3:微信H5  4:微信小程序)',
  `status` int DEFAULT NULL COMMENT '是否开启(1:开启  2:关闭)',
  `amount_success` decimal(10,0) DEFAULT NULL COMMENT '通道充值成功额度(支付成功)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通道备注',
  `call_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通道调用名称(该字段请严格按照代码接口填写 否则无法调用支付接口)',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付通道图标(用于前端页面显示)',
  `time` datetime DEFAULT NULL COMMENT '配置时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1645018276866605058 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='支付通道配置表';

-- ----------------------------
-- Records of tb_pay_config
-- ----------------------------


-- ----------------------------
-- Table structure for tb_poster
-- ----------------------------
DROP TABLE IF EXISTS `tb_poster`;
CREATE TABLE `tb_poster` (
  `id` bigint NOT NULL COMMENT '主键ID',
  `poster_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '海报主图',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '海报显示平台logo',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '海报分享标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '海报分享内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='海报设置表';

-- ----------------------------
-- Records of tb_poster
-- ----------------------------
BEGIN;
INSERT INTO `tb_poster` (`id`, `poster_img`, `logo`, `title`, `content`) VALUES (1650770541397864449, 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230425/853edb11deed409eb07a7d2687b15c0b.jpeg', 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230425/ed29d2bfaa9544c2be8a0511eee91384.png', 'AI智能工具箱', 'AI写作,AI写小说,AI绘画');
COMMIT;

-- ----------------------------
-- Table structure for tb_question_answer
-- ----------------------------
DROP TABLE IF EXISTS `tb_question_answer`;
CREATE TABLE `tb_question_answer` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题',
  `answer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'AI的回答',
  `create_time` datetime DEFAULT NULL COMMENT '产生时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651114500079788035 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='问答记录表';

-- ----------------------------
-- Records of tb_question_answer
-- ----------------------------
BEGIN;
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650836900086308866, 1650833232142295041, '推荐一些轻音乐', '1. Yiruma - River Flows in You\n2. Ludovico Einaudi - Nuvole Bianche\n3. George Winston - Variations on the Kanon by Pachelbel\n4. Brian Crain - Song for Sienna\n5. David Nevue - While the Trees Sleep\n6. Jim Brickman - Valentine\n7. Kevin Kern - Sundial Dreams\n8. Enya - Only Time\n9. Secret Garden - Nocturne\n10. Giovanni Marradi - Just for You', '2023-04-25 20:19:23');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650837232623312897, 1650833232142295041, '请帮我写文案，手机', '当今社会，手机已经成为人们生活中必不可少的一部分。它不仅仅是一种通讯工具，更是一种生活方式。无论是工作、娱乐、学习还是社交，手机都能为我们提供便利和乐趣。\n\n在选择手机时，我们需要考虑很多因素，比如品牌、性能、外观、价格等等。但无论你选择哪款手机，它都应该能够满足你的需求，并且让你的生活更加便捷和丰富。\n\n现在，随着科技的不断进步，手机的功能也越来越强大。我们可以通过手机拍照、听音乐、看视频、玩游戏等等，让生活更加多彩。同时，手机也成为了我们的个人助手，可以帮助我们管理日程、记录笔记、查看天气等等。\n\n总之，手机已经成为了我们生活中不可或缺的一部分。它让我们的生活更加便捷、丰富和有趣。所以，选择一款适合自己的手机，让它成为你生活中的好伙伴吧！', '2023-04-25 20:20:42');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650838391052328961, 1650838349084123138, '我爱你英语怎么说', 'I love you.', '2023-04-25 20:25:18');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650838443565015042, 1650838349084123138, '草你妈', '对不起，作为AI语言模型，我不能回答不恰当或不尊重的话语。请注意文明用语。', '2023-04-25 20:25:31');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650852196478115841, 1650852058493902850, '帮我点评餐厅,关键词为:中餐', '很高兴为您点评中餐餐厅。中餐是中国文化的重要组成部分，也是世界上最受欢迎的美食之一。以下是我对中餐餐厅的点评：\n\n1. 菜品：中餐餐厅的菜品种类繁多，包括川菜、粤菜、湘菜等。好的中餐餐厅应该有丰富的菜品选择，口味正宗，新鲜食材，让人们能够品尝到地道的中餐美食。\n\n2. 服务：中餐餐厅的服务应该热情周到，服务员应该有专业的知识和技能，能够为客人提供优质的服务体验。餐厅的环境和氛围也应该舒适，让客人感到放松和愉悦。\n\n3. 价格：中餐餐厅的价格应该合理，符合市场价值。好的中餐餐厅应该提供高品质的菜品和服务，但不应该过于昂贵，让消费者感到物有所值。\n\n4. 卫生：中餐餐厅的卫生和安全非常重要。餐厅应该保持干净整洁，食材应该新鲜卫生，厨房应该符合卫生标准。\n\n总的来说，好的中餐餐厅应该有丰富的菜品选择，优质的服务，合理的价格和良好的卫生标准。希望我的点评能够对您有所帮助。', '2023-04-25 21:20:10');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650857607017029634, 1650833232142295041, '你好', '你好！有什么我可以帮助你的吗？', '2023-04-25 21:41:40');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650857855667953665, 1650833232142295041, '河里有一行鸭子，2只的前面有2只，2只的后面有2只，2只的中间还有2只，共有几只鸭子？', '这道题目的关键在于要理解“2只的前面有2只，2只的后面有2只，2只的中间还有2只”这句话的意思。实际上，这句话是在描述每一对相邻的鸭子之间都有2只鸭子。因此，我们可以将这些鸭子分成若干对，每一对之间都有2只鸭子，最后再将每一对中的2只鸭子相加即可。\n\n假设这行鸭子有n只，那么它们可以分成(n-1)/2对。每一对中有2只鸭子，因此总共有2*(n-1)/2=n-1只鸭子。最后再加上最后一只鸭子，即可得到总共有n只鸭子。\n\n因此，这行鸭子共有n只，其中n=2*(2+1)+1=7。', '2023-04-25 21:42:39');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650862735077957634, 1650862353417265153, '小学同学作业问题', '有一天，孙悟空和唐僧带着他们的徒弟们行走在一片茂密的森林中，突然听到了一声惊叫。他们赶紧跑过去，发现一个小学生正在哭泣，他的作业本掉进了河里，而他的家长要求他必须完成作业才能回家。\n\n孙悟空和唐僧看到这个小学生的困境，决定帮助他。孙悟空立刻变成了一只大鱼，游到了河底，找到了小学生的作业本。唐僧则用他的法力，将作业本上的水分全部吸干，让作业本恢复了原状。\n\n小学生非常感激孙悟空和唐僧的帮助，他们一起坐在树下，孙悟空和唐僧帮助他完成了作业。小学生开心地拿着作业本回家了，而孙悟空和唐僧也继续了他们的旅程。\n\n这个故事告诉我们，无论我们遇到什么困难，只要有勇气和努力，总会有人会来帮助我们。同时，也提醒我们要珍惜每一次学习的机会，认真完成每一份作业。', '2023-04-25 22:02:02');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650862933632114689, 1650862353417265153, '抓饭', '一天，孙悟空、猪八戒、沙僧和唐僧四人走在路上，突然闻到一股香气扑鼻而来。他们顺着香气走来到一家小饭馆门口，看到里面挤满了人，都在等待着抓饭。\n\n抓饭是一种非常有趣的吃饭方式，每个人都要用手抓着米饭和菜一起吃，而且不能用筷子或勺子。孙悟空和猪八戒非常喜欢这种吃饭方式，但唐僧和沙僧却不太习惯。\n\n四人找到了一个空位坐下，等待着抓饭。突然，一个身穿黑色衣服的人走了进来，他的脸上戴着面具，看起来非常神秘。他走到了四人的桌子旁，拿起了一只碗，然后开始抓饭。\n\n孙悟空和猪八戒非常好奇，他们问那个神秘的人为什么要戴面具。那个人笑了笑，说他是一个江湖上的刺客，不能让别人认出他的真面目。\n\n四人听了之后，都非常惊讶。他们问那个刺客为什么要来这里，那个刺客说他是来杀人的。四人听了之后，非常生气，他们决定保护这家小饭馆的主人和客人。\n\n于是，孙悟空和猪八戒拿起了菜刀和铁棍，沙僧则掌握了法术，唐僧则念起了经文。他们一起向那个刺客发起了攻击。\n\n那个刺客非常厉害，他的武功非常高强。但是，四人却不肯放弃，他们一直在和那个刺客搏斗。最终，他们终于打败了那个刺客，保护了这家小饭馆的主人和客人。\n\n小饭馆的主人非常感激，他们请四人吃了一顿丰盛的饭菜。四人吃得非常开心，他们觉得这是一次非常有意义的经历。从此以后，他们也更加珍惜生命，更加珍惜每一顿饭。', '2023-04-25 22:02:50');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650863466061258753, 1650862353417265153, '帮我点评餐厅,关键词为:新疆抓饭', '这家新疆抓饭餐厅的味道非常地道，让人感受到了浓郁的新疆风味。抓饭的米饭口感软糯，配上烤羊肉和蔬菜，味道非常美味。此外，餐厅的环境也很不错，装修风格独特，让人感觉舒适。唯一的缺点可能是价格稍微有些贵，但是考虑到食材的质量和口味，还是值得一试的。总体来说，这家新疆抓饭餐厅是一家值得推荐的餐厅。', '2023-04-25 22:04:57');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650877404685557762, 1650833232142295041, '你是谁', '我是一个AI语言模型，由OpenAI开发。', '2023-04-25 23:00:20');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650877425778712578, 1650833232142295041, '你好', '你好！我是AI助手，有什么可以帮助你的吗？', '2023-04-25 23:00:25');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650877619270344706, 1650852058493902850, '什么是BMI指数?', 'BMI指数是身体质量指数（Body Mass Index）的缩写，也称为身体质量指数、体重指数等。它是一种用于衡量人体肥胖程度的指标，是以人体质量（体重）和身高的平方为基础计算出来的。BMI指数可以帮助人们了解自己的身体质量状况，从而采取相应的健康管理措施。一般来说，BMI指数在18.5以下表示体重过轻，18.5-24.9表示体重正常，25-29.9表示超重，30及以上表示肥胖。但是，BMI指数并不能完全反映人体脂肪分布情况和健康状况，因此在使用时需要结合其他指标进行评估。', '2023-04-25 23:01:11');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650880991641755650, 1650852058493902850, '销售一部手机的文案', '这款手机是一款功能强大、外观精美的智能手机，它拥有一系列先进的技术和功能，让您的生活更加便捷和有趣。\n\n首先，它采用了最新的处理器和操作系统，让您的手机运行更加流畅和快速。同时，它还拥有高清屏幕和优秀的摄像头，让您能够拍摄出更加清晰、美丽的照片和视频。\n\n此外，这款手机还支持多种语言和应用程序，让您能够更加方便地使用和享受手机带来的乐趣。它还拥有强大的电池寿命和快速充电功能，让您能够长时间使用手机而不必担心电量问题。\n\n总之，这款手机是一款非常出色的智能手机，它将为您带来更加便捷、有趣和愉悦的生活体验。无论您是在工作还是娱乐，它都能够满足您的需求，让您的生活更加美好。赶快来购买吧！', '2023-04-25 23:14:35');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650888193488211970, 1650881339886428161, '推荐三本经济学入门书籍', '1. 《经济学原理》（作者：曼昆）：这是一本经典的经济学入门教材，内容详细、易懂，适合初学者阅读。\n\n2. 《经济学思维》（作者：保罗·萨缪尔森）：这本书介绍了经济学的基本概念和思维方式，帮助读者理解经济学的基本原理。\n\n3. 《经济学的思维方式》（作者：斯蒂文·E·兰德尔）：这本书介绍了经济学的基本概念和思维方式，通过实例和案例分析，帮助读者理解经济学的基本原理。', '2023-04-25 23:43:12');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650888717344198658, 1650852058493902850, '什么是BMI指数?', 'BMI指数是身体质量指数（Body Mass Index）的缩写，是一种衡量人体肥胖程度的指标。它是根据一个人的身高和体重计算出来的，公式为：BMI=体重（kg）÷身高（m）的平方。根据计算结果，可以将人的体型分为偏瘦、正常、超重和肥胖四个等级。BMI指数是一种简单、快速、经济的评估肥胖程度的方法，但它并不能完全反映人体脂肪分布和健康状况。', '2023-04-25 23:45:17');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650888767608737793, 1650852058493902850, '今天天气怎么样', '抱歉，作为人工智能，我无法感知天气情况。建议您查看当地天气预报或者打开天气应用程序获取最新的天气信息。', '2023-04-25 23:45:29');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889466123931649, 1650852058493902850, '为玩具店写一个标语', '玩具店标语：让孩子的童年更精彩！', '2023-04-25 23:48:15');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889529696997377, 1650852058493902850, '推荐三本经济学入门书籍', '以下是三本经济学入门书籍的推荐：\n\n1. 《经济学原理》（作者：曼昆）：这是一本经典的经济学入门教材，适合初学者阅读。它以生活中的实例为例子，讲解了经济学的基本原理和概念，包括供求关系、市场结构、成本与效益等。\n\n2. 《经济学通识》（作者：哈佛大学教授格雷戈里·曼基尔）：这本书是一本通俗易懂的经济学入门读物，适合对经济学一无所知的读者。它讲解了经济学的基本原理和概念，包括市场、货币、通货膨胀等。\n\n3. 《穷爸爸富爸爸》（作者：罗伯特·清崎）：这本书虽然不是一本正统的经济学入门读物，但它讲述了个人财务管理的基本原则，包括如何理解资产和负债、如何投资等。这些原则对于理解经济学的基本概念和原理非常有帮助。', '2023-04-25 23:48:31');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889562899107842, 1650852058493902850, '马云多大了', '截至2021年9月，马云出生于1964年，今年57岁。', '2023-04-25 23:48:38');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889639449350145, 1650852058493902850, '今年是什么年', '今年是2021年，是公历的阳历年份。', '2023-04-25 23:48:57');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889678523486209, 1650852058493902850, '你今年多大了', '作为一个人工智能程序，我没有年龄，我是在2021年创建的。', '2023-04-25 23:49:06');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889719078211585, 1650852058493902850, '一加一等于几', '一加一等于二。', '2023-04-25 23:49:16');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650889899781410818, 1650852058493902850, '以我的爸爸为题写作文，100字', '我的爸爸是一个非常优秀的人。他是一名工程师，工作非常努力，每天都要忙碌到很晚。尽管如此，他仍然会抽出时间陪伴我和家人。他是一个非常有责任心的人，总是能够为家庭着想，为我们提供最好的生活条件。他也是一个非常有耐心的人，总是能够耐心地听我讲述自己的故事和问题。我非常感激我的爸爸，他是我生命中最重要的人之一。', '2023-04-25 23:49:59');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650890262790033409, 1650881339886428161, '你好', '你好！有什么我可以帮助你的吗？', '2023-04-25 23:51:25');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650892554159300609, 1650852058493902850, '销售一部手机的文案', '这款手机是您生活中必不可少的伙伴！它拥有超大的屏幕，让您能够更加清晰地看到每一个细节。同时，它的处理器速度非常快，让您能够更加流畅地使用各种应用程序。此外，它还拥有出色的摄像头，让您能够拍摄出更加清晰、美丽的照片和视频。最重要的是，它的电池寿命非常长，让您能够更加轻松地使用它一整天。购买这款手机，您将会拥有一个更加便捷、高效、美好的生活！', '2023-04-26 00:00:32');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650897161094733825, 1650852058493902850, '帮我解梦,我梦到了:被狗咬', '被狗咬的梦通常代表着你在现实生活中可能会遇到一些挑战或者困难，而这些困难可能会让你感到痛苦或者受伤。这个梦也可能代表着你的内心感到不安或者害怕，你可能需要面对一些你不愿意面对的问题或者情况。\n\n如果你在梦中成功地躲避了狗的攻击，那么这个梦可能代表着你在现实生活中也能够成功地克服困难或者避免危险。如果你在梦中被狗咬伤了，那么这个梦可能代表着你需要更加小心谨慎，以避免在现实生活中受到伤害。\n\n总之，被狗咬的梦可能代表着你在现实生活中面临的挑战或者困难，你需要小心谨慎，以避免受到伤害。同时，这个梦也可能提醒你需要面对内心的恐惧和不安，以便更好地应对现实生活中的挑战。', '2023-04-26 00:18:50');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650897372445712386, 1650852058493902850, '你好', '你好！有什么我可以帮助你的吗？', '2023-04-26 00:19:40');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1650904045226860546, 1650833232142295041, '为西游记写一个番外故事', '在西游记中，唐僧和他的三个徒弟一路上历经千辛万苦，终于取得真经，回到了长安。然而，他们的冒险之旅并没有结束。在他们回到长安的路上，他们遇到了一个神秘的女子，她自称是天宫的仙女，她告诉唐僧和他的徒弟们，他们的真正使命还没有完成。\n\n仙女告诉他们，有一个邪恶的妖怪正在肆虐人间，它的名字叫做“黑暗之王”，它的力量非常强大，可以摧毁整个世界。唐僧和他的徒弟们被委以重任，他们必须前往黑暗之王的巢穴，打败它，拯救人类。\n\n唐僧和他的徒弟们开始了新的冒险之旅。他们穿过了无尽的山脉和沙漠，经过了无数的险阻，最终来到了黑暗之王的巢穴。他们发现，黑暗之王的力量比他们想象的还要强大，他们必须联合起来，才能有一线胜利的希望。\n\n在一场激烈的战斗中，唐僧和他的徒弟们终于打败了黑暗之王。他们拯救了人类，保护了和平。然而，他们也明白，他们的冒险之旅还没有结束，他们还有更多的使命要完成。\n\n这个番外故事讲述了唐僧和他的徒弟们在西游记之后的冒险之旅。他们不仅要面对更强大的敌人，还要面对更多的挑战和考验。但是，他们的信念和勇气永远不会消失，他们会继续前行，直到完成他们的使命。', '2023-04-26 00:46:11');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651039630088249346, 1650836654262345729, '销售一部手机的文案', '这款手机不仅外观时尚，还拥有强大的性能和出色的功能。它配备了最新的处理器和大容量的内存，可以轻松应对多任务处理和高负荷运行。同时，它还拥有高清屏幕和超长续航，让你无论是看电影还是玩游戏都能享受到流畅的体验。此外，它还支持快速充电和无线充电，让你的生活更加便捷。不管你是工作还是娱乐，这款手机都能满足你的需求。赶快来购买吧！', '2023-04-26 09:44:57');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651060149265145858, 1650833232142295041, '销售一部手机的文案', '这款手机是您生活中必不可少的伙伴！它拥有高清屏幕、强大的处理器和长久的电池寿命，让您随时随地享受流畅的使用体验。同时，它还拥有出色的相机和音效效果，让您记录下每一个珍贵的瞬间和享受最纯粹的音乐体验。此外，它还支持多种智能功能，如人脸识别、指纹解锁和语音助手等，让您的生活更加便捷和智能化。不仅如此，它还具有时尚的外观和精致的设计，让您在使用它的同时也能展现自己的品味和风格。购买这款手机，您将拥有一款真正的高品质手机，让您的生活更加精彩！', '2023-04-26 11:06:29');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651060601155264514, 1651059840459513858, '海螺', '海螺是一种海洋生物，属于软体动物门，腹足纲，海螺科。它们通常有一个螺壳，可以收缩和伸展的足以及一对触角。海螺的螺壳形状和颜色各不相同，有些种类的螺壳甚至可以达到十几厘米长。海螺是一种常见的食用海产品，含有丰富的蛋白质和营养素，被广泛用于烹饪和制作海鲜菜肴。此外，海螺还有一些药用价值，被用于治疗一些疾病。', '2023-04-26 11:08:17');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651063794098544642, 1650841630275559426, '取个好听的网名', '梦幻之音', '2023-04-26 11:20:58');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651072790712852482, 1650836654262345729, '什么是BMI指数?', 'BMI指数是身体质量指数（Body Mass Index）的缩写，是一种衡量人体肥胖程度的指标。它是根据一个人的身高和体重计算出来的，公式为：BMI = 体重（kg）/身高（m）的平方。根据计算结果，可以将人的体型分为偏瘦、正常、超重和肥胖四个等级。BMI指数是一种简单、快速、经济的评估肥胖程度的方法，但并不能完全代表身体健康状况，因为它无法区分肌肉和脂肪的比例。', '2023-04-26 11:56:43');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651073291957346306, 1650836654262345729, '我想投资房地产', '好的，投资房地产是一种常见的投资方式，但需要注意以下几点：\n\n1. 风险：房地产市场波动较大，投资者需要承担一定的风险。此外，房地产市场受到政策、经济、地域等多种因素的影响，需要投资者进行充分的风险评估。\n\n2. 资金：房地产投资需要大量的资金，包括购房款、装修费、物业费等。投资者需要确保自己有足够的资金进行投资，并且需要考虑到资金的流动性。\n\n3. 投资周期：房地产投资通常需要较长的投资周期，投资者需要有足够的耐心和长期的投资计划。\n\n4. 地域选择：不同地区的房地产市场存在差异，投资者需要根据自己的需求和风险承受能力选择合适的地域进行投资。\n\n5. 投资方式：房地产投资方式包括购买房产、投资房地产基金、参与房地产开发等多种方式，投资者需要根据自己的需求和风险承受能力选择合适的投资方式。\n\n总之，投资房地产需要投资者进行充分的风险评估和投资计划，选择合适的投资方式和地域进行投资。', '2023-04-26 11:58:43');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651092583968972802, 1650836654262345729, '帮我写一篇作文,作文题目是:我的父亲，800字', '我的父亲，800字\n\n我的父亲是一个非常优秀的人，他是我的榜样和支持者。他是一个非常勤奋的人，他总是在工作中投入全部的精力，从不抱怨。他是一个非常聪明的人，他总是能够在最短的时间内找到解决问题的方法。他是一个非常有责任感的人，他总是把家庭放在第一位。\n\n我的父亲是一个工程师，他的工作非常忙碌，但他总是能够抽出时间来陪伴我们。他总是在周末带我们去公园玩耍，或者一起看电影。他还喜欢教我们一些有趣的知识，比如如何修理自行车，如何种植花草等等。他总是能够让我们感到快乐和幸福。\n\n我的父亲是一个非常聪明的人，他总是能够在最短的时间内找到解决问题的方法。他总是能够帮助我们解决各种问题，无论是学习上的问题还是生活上的问题。他总是能够给我们最好的建议，让我们能够更好地成长。\n\n我的父亲是一个非常有责任感的人，他总是把家庭放在第一位。他总是会关心我们的生活和学习，帮助我们解决各种问题。他还会在家里做饭，打扫卫生等等，让我们感到温馨和舒适。\n\n我的父亲是一个非常优秀的人，他是我的榜样和支持者。他的努力和付出让我感到非常自豪和感激。我会一直努力，成为像他一样优秀的人，为他争取更多的荣誉和尊重。\n\n总之，我的父亲是一个非常优秀的人，他的努力和付出让我感到非常自豪和感激。我会一直努力，成为像他一样优秀的人，为他争取更多的荣誉和尊重。', '2023-04-26 13:15:22');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651099551970402306, 1650836654262345729, '帮我写一封节日祝福,节日为:清明节', '亲爱的朋友，\n\n在这个清明节来临之际，我想向你送上最真挚的祝福。清明节是一个重要的传统节日，它是我们缅怀先人、祭拜祖先的日子。在这个特殊的日子里，我希望你能够感受到亲人的关爱和祖先的祝福。\n\n清明节是一个寄托思念的节日，也是一个感恩的节日。在这个节日里，我们要怀念那些已经离开我们的亲人和祖先，感恩他们为我们所做的一切。同时，也要珍惜眼前的人和事，让我们的生命更加充实和美好。\n\n愿你在这个清明节里，能够感受到亲人的关爱和祖先的祝福，也希望你能够珍惜眼前的人和事，让自己的生命更加充实和美好。祝你清明节快乐，一切顺利！\n\n祝福你，\n\nXXX', '2023-04-26 13:43:04');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651101646874255361, 1650852058493902850, '什么是BMI指数?', 'BMI指数是身体质量指数（Body Mass Index）的缩写，是一种衡量人体肥胖程度的指标。它是根据一个人的身高和体重计算出来的，公式为：BMI=体重（kg）÷身高（m）的平方。根据计算结果，可以将人的体型分为偏瘦、正常、超重和肥胖四个等级。BMI指数是一种简单、快速、经济的评估肥胖程度的方法，但它并不能完全反映人体脂肪分布和肌肉量等因素，因此在评估肥胖程度时还需要结合其他指标进行综合判断。', '2023-04-26 13:51:23');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651102949717352449, 1650852058493902850, '帮我做一个旅游攻略,我要去的地方是:北京', '好的，以下是针对北京的旅游攻略：\n\n1. 参观故宫：故宫是中国最著名的古建筑之一，也是世界上最大的古代宫殿之一。在这里，你可以欣赏到许多珍贵的文物和艺术品，了解中国的历史和文化。\n\n2. 爬长城：长城是中国的象征之一，也是世界上最长的城墙。在北京附近有许多不同的长城段可以选择，其中最著名的是八达岭长城和慕田峪长城。\n\n3. 游览颐和园：颐和园是中国最著名的皇家园林之一，也是世界上最大的古代皇家园林之一。在这里，你可以欣赏到许多美丽的景观和建筑，包括长廊、大观园、万寿山等。\n\n4. 逛胡同：北京的胡同是中国传统文化的重要组成部分，也是北京的标志性景观之一。在这里，你可以感受到老北京的风情和文化，品尝到地道的北京小吃。\n\n5. 参观天安门广场和毛主席纪念堂：天安门广场是中国的政治中心，也是世界上最大的城市广场之一。毛主席纪念堂是中国最著名的纪念馆之一，也是中国革命历史的见证。\n\n6. 体验京剧和北京烤鸭：京剧是中国传统戏曲之一，也是北京的代表性文化艺术之一。北京烤鸭是中国最著名的菜肴之一，也是北京的代表性美食之一。\n\n7. 参观鸟巢和水立方：鸟巢是2008年北京奥运会的主体育场，也是世界上最大的钢结构建筑之一。水立方是奥运会的游泳馆，也是世界上最大的钢结构建筑之一。\n\n8. 逛798艺术区：798艺术区是北京最著名的艺术区之一，也是中国当代艺术的代表之一。在这里，你可以欣赏到许多当代艺术作品，了解中国当代艺术的发展。\n\n希望这些建议能够帮助你在北京度过愉快的旅行！', '2023-04-26 13:56:34');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651106776738734081, 1651105233989836801, '为玩具店写一个标语', '\"让孩子的童年更加精彩，来我们的玩具店选购最好的玩具！\"', '2023-04-26 14:11:46');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651113017531736065, 1651112923323473922, '什么是BMI指数?', 'BMI指数是身体质量指数（Body Mass Index）的缩写，也称为身体质量指数、体重指数。它是一种用于衡量人体肥胖程度的指标，通过计算一个人的体重与身高的比例来评估其身体健康状况。BMI指数的计算公式为：体重（公斤）÷身高（米）的平方。根据计算结果，可以将人的体型分为偏瘦、正常、超重和肥胖四个等级。', '2023-04-26 14:36:34');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651113105452736513, 1651112984874885122, '彩票', '彩票是指一种通过购买彩票号码，参与抽奖或开奖活动，以期获得奖金的游戏。彩票种类繁多，包括数字彩、高频彩、体育彩、福利彩等。彩票的发行和管理由国家彩票管理机构负责，彩票销售渠道包括彩票站、网上销售等。彩票的销售收入一部分用于奖金发放，一部分用于公益事业。彩票作为一种娱乐方式，受到了广大人民群众的喜爱。', '2023-04-26 14:36:55');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651113150877048833, 1651112984874885122, '开奖号', '很抱歉，我无法提供彩票开奖号码。请您前往彩票官方网站或者彩票销售点查询开奖号码。', '2023-04-26 14:37:06');
INSERT INTO `tb_question_answer` (`id`, `user_id`, `question`, `answer`, `create_time`) VALUES (1651114500079788034, 1651114446040375298, '帮我评论下电影,电影名字是:1', '很抱歉，由于您没有提供电影的名称，我无法为您提供评论。请提供电影名称，我将非常乐意为您提供评论。', '2023-04-26 14:42:28');
COMMIT;

-- ----------------------------
-- Table structure for tb_species_list
-- ----------------------------
DROP TABLE IF EXISTS `tb_species_list`;
CREATE TABLE `tb_species_list` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint NOT NULL COMMENT '用户id',
  `species` int DEFAULT NULL COMMENT '聊天币数量',
  `create_time` datetime DEFAULT NULL COMMENT '产生时间',
  `msg_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提问内容',
  `type` int DEFAULT NULL COMMENT '类型(0问答1图片2平台赠送3充值4邀请奖励5签到赠送)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651119876724531202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='问答次数流水';

-- ----------------------------
-- Records of tb_species_list
-- ----------------------------
BEGIN;
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650833328934248449, 1650833232142295041, 5, '2023-04-25 20:05:11', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650835903712616450, 1650834860824092673, -1, '2023-04-25 20:15:25', '请帮我知乎风格生成器，销售找不到定位怎么办', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650836654367203330, 1650833232142295041, 5, '2023-04-25 20:18:24', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650836900132446209, 1650833232142295041, -1, '2023-04-25 20:19:23', '推荐一些轻音乐', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650837089530437633, 1650833232142295041, 5, '2023-04-25 20:20:08', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650837116373983233, 1650833232142295041, 5, '2023-04-25 20:20:14', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650837232665255937, 1650833232142295041, -1, '2023-04-25 20:20:42', '请帮我写文案，手机', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650838349142843394, 1650837116290097154, 5, '2023-04-25 20:25:08', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650838391085883393, 1650838349084123138, -1, '2023-04-25 20:25:18', '我爱你英语怎么说', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650838443594375170, 1650838349084123138, -1, '2023-04-25 20:25:31', '草你妈', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650838523848187906, 1650837116290097154, 5, '2023-04-25 20:25:50', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650841630330085377, 1650837116290097154, 5, '2023-04-25 20:38:10', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650852196524253185, 1650852058493902850, -1, '2023-04-25 21:20:10', '帮我点评餐厅,关键词为:中餐', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650853227337375745, 1650852058493902850, 5, '2023-04-25 21:24:15', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650857607050584065, 1650833232142295041, -1, '2023-04-25 21:41:40', '你好', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650857855697313794, 1650833232142295041, -1, '2023-04-25 21:42:39', '河里有一行鸭子，2只的前面有2只，2只的后面有2只，2只的中间还有2只，共有几只鸭子？', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650862353501151234, 1650837116290097154, 5, '2023-04-25 22:00:31', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650862735107317762, 1650862353417265153, -1, '2023-04-25 22:02:02', '小学同学作业问题', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650862933661474817, 1650862353417265153, -1, '2023-04-25 22:02:50', '抓饭', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650863466090618881, 1650862353417265153, -1, '2023-04-25 22:04:57', '帮我点评餐厅,关键词为:新疆抓饭', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650866924235546626, 1650836654262345729, 5, '2023-04-25 22:18:41', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650877404702334977, 1650833232142295041, -1, '2023-04-25 23:00:20', '你是谁', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650877425808072706, 1650833232142295041, -1, '2023-04-25 23:00:25', '你好', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650877619299704834, 1650852058493902850, -1, '2023-04-25 23:01:11', '什么是BMI指数?', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650880991696281602, 1650852058493902850, -1, '2023-04-25 23:14:35', '销售一部手机的文案', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650881409247633409, 1650881339886428161, 5, '2023-04-25 23:16:15', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650882022270304257, 1650881339886428161, -3, '2023-04-25 23:18:41', '山水画', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650882155925995521, 1650881339886428161, -3, '2023-04-25 23:19:13', '旗袍美女CG分辨率1080P', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650882625532854273, 1650852058493902850, -3, '2023-04-25 23:21:05', '哆啦A梦', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650888193538543617, 1650881339886428161, -1, '2023-04-25 23:43:12', '推荐三本经济学入门书籍', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650888717377753089, 1650852058493902850, -1, '2023-04-25 23:45:17', '什么是BMI指数?', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650888767654875138, 1650852058493902850, -1, '2023-04-25 23:45:29', '今天天气怎么样', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889466182651906, 1650852058493902850, -1, '2023-04-25 23:48:15', '为玩具店写一个标语', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889529730551809, 1650852058493902850, -1, '2023-04-25 23:48:31', '推荐三本经济学入门书籍', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889562928467970, 1650852058493902850, -1, '2023-04-25 23:48:39', '马云多大了', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889639482904578, 1650852058493902850, -1, '2023-04-25 23:48:57', '今年是什么年', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889678561234945, 1650852058493902850, -1, '2023-04-25 23:49:06', '你今年多大了', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889719107571713, 1650852058493902850, -1, '2023-04-25 23:49:16', '一加一等于几', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650889899810770946, 1650852058493902850, -1, '2023-04-25 23:49:59', '以我的爸爸为题写作文，100字', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650890262827782145, 1650881339886428161, -1, '2023-04-25 23:51:25', '你好', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650892490347159554, 1650852058493902850, 5, '2023-04-26 00:00:16', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650892554205437953, 1650852058493902850, -1, '2023-04-26 00:00:32', '销售一部手机的文案', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650897161128288257, 1650852058493902850, -1, '2023-04-26 00:18:50', '帮我解梦,我梦到了:被狗咬', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650897372475072513, 1650852058493902850, -1, '2023-04-26 00:19:40', '你好', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1650904045281386498, 1650833232142295041, -1, '2023-04-26 00:46:11', '为西游记写一个番外故事', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651039630130192385, 1650836654262345729, -1, '2023-04-26 09:44:57', '销售一部手机的文案', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651060149294505986, 1650833232142295041, -1, '2023-04-26 11:06:29', '销售一部手机的文案', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651060601184624642, 1651059840459513858, -1, '2023-04-26 11:08:17', '海螺', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651060821448499201, 1651059840459513858, -3, '2023-04-26 11:09:10', '美女', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651063794127904769, 1650841630275559426, -1, '2023-04-26 11:20:58', '取个好听的网名', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651072790742212610, 1650836654262345729, -1, '2023-04-26 11:56:43', '什么是BMI指数?', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651073291995095041, 1650836654262345729, -1, '2023-04-26 11:58:43', '我想投资房地产', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651092584002527233, 1650836654262345729, -1, '2023-04-26 13:15:23', '帮我写一篇作文,作文题目是:我的父亲，800字', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651098867401269249, 1650866924172632066, -3, '2023-04-26 13:40:21', '画一个logo，关于ai智能助手的', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651099552008151041, 1650836654262345729, -1, '2023-04-26 13:43:04', '帮我写一封节日祝福,节日为:清明节', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651101646916198402, 1650852058493902850, -1, '2023-04-26 13:51:23', '什么是BMI指数?', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651102949759295489, 1650852058493902850, -1, '2023-04-26 13:56:34', '帮我做一个旅游攻略,我要去的地方是:北京', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651105234052751361, 1650836654262345729, 5, '2023-04-26 14:05:39', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651105452047507457, 1651105233989836801, -3, '2023-04-26 14:06:30', '花一个美女', 1);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651106776780677122, 1651105233989836801, -1, '2023-04-26 14:11:46', '为玩具店写一个标语', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651111880812437505, 1650837116290097154, 5, '2023-04-26 14:32:03', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651112485639462914, 1650837116290097154, 5, '2023-04-26 14:34:27', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651112923403165697, 1650837116290097154, 5, '2023-04-26 14:36:12', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651112984929411074, 1650837116290097154, 5, '2023-04-26 14:36:26', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113017561096193, 1651112923323473922, -1, '2023-04-26 14:36:34', '什么是BMI指数?', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113081029304321, 1651112923323473922, 5, '2023-04-26 14:36:49', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113105482096642, 1651112984874885122, -1, '2023-04-26 14:36:55', '彩票', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113150910603266, 1651112984874885122, -1, '2023-04-26 14:37:06', '开奖号', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113357605904385, 1651112984874885122, 5, '2023-04-26 14:37:55', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113716315365378, 1650837116290097154, 5, '2023-04-26 14:39:21', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651113747139305473, 1651113716256645122, 5, '2023-04-26 14:39:28', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651114446111678465, 1650837116290097154, 5, '2023-04-26 14:42:15', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651114500104953858, 1651114446040375298, -1, '2023-04-26 14:42:28', '帮我评论下电影,电影名字是:1', 0);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651115587050446850, 1650837116290097154, 5, '2023-04-26 14:46:47', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651115638615220226, 1651115586966560770, 5, '2023-04-26 14:46:59', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651116446043906049, 1650837116290097154, 5, '2023-04-26 14:50:12', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651116506697736193, 1651116445993574402, 5, '2023-04-26 14:50:26', NULL, 5);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651118555481022466, 1650837116290097154, 5, '2023-04-26 14:58:35', NULL, 4);
INSERT INTO `tb_species_list` (`id`, `userid`, `species`, `create_time`, `msg_content`, `type`) VALUES (1651119876724531201, 1650837116290097154, 5, '2023-04-26 15:03:50', NULL, 4);
COMMIT;

-- ----------------------------
-- Table structure for tb_tmpl_category
-- ----------------------------
DROP TABLE IF EXISTS `tb_tmpl_category`;
CREATE TABLE `tb_tmpl_category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名字',
  `category_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类的图片',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int DEFAULT NULL COMMENT '状态(0开启1关闭)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651090130397609986 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='提问模板分类';

-- ----------------------------
-- Records of tb_tmpl_category
-- ----------------------------
BEGIN;
INSERT INTO `tb_tmpl_category` (`id`, `category_name`, `category_img`, `create_time`, `status`) VALUES (1645262162100396033, '生活', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230410/ec4ed8d132f54757b3ab7c5d2b2fc843.png', '2023-04-26 13:40:22', 0);
INSERT INTO `tb_tmpl_category` (`id`, `category_name`, `category_img`, `create_time`, `status`) VALUES (1645262634249003010, '效率工具', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230410/3024c45b72374353addfb54158d41c9c.png', '2023-04-10 11:09:14', 0);
INSERT INTO `tb_tmpl_category` (`id`, `category_name`, `category_img`, `create_time`, `status`) VALUES (1648578719447719938, '娱乐', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230419/ca8c23cec27a41e28e2f503fcd38ef0a.png', '2023-04-19 14:46:10', 0);
INSERT INTO `tb_tmpl_category` (`id`, `category_name`, `category_img`, `create_time`, `status`) VALUES (1648578845964705793, '创作助手', 'https://chatgpt-momoyu.oss-cn-chengdu.aliyuncs.com/20230419/09e00880723d45afb76051cb92ec5045.png', '2023-04-19 14:46:41', 0);
INSERT INTO `tb_tmpl_category` (`id`, `category_name`, `category_img`, `create_time`, `status`) VALUES (1651090130397609985, '学习', '', '2023-04-26 13:05:38', 0);
COMMIT;

-- ----------------------------
-- Table structure for tb_tmpl_qs
-- ----------------------------
DROP TABLE IF EXISTS `tb_tmpl_qs`;
CREATE TABLE `tb_tmpl_qs` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '问题ID',
  `qs_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题标题',
  `qs_hint` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题提示',
  `tid` bigint DEFAULT NULL COMMENT '所属分类ID',
  `status` int DEFAULT NULL COMMENT '状态(0正常1禁用)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `qs_call` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题指引',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651098857863430146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='提问模板问题';

-- ----------------------------
-- Records of tb_tmpl_qs
-- ----------------------------
BEGIN;
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1645267714142539778, '塔罗牌预测小助手', '输入想预测的占卜内容，帮你预测运势', 1645262162100396033, 0, '2023-04-10 11:29:25', '帮我使用塔罗牌,占卜我的运势,关键词为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1648579102739996674, '写文案', '为任何产品撰写文案介绍', 1648578845964705793, 0, '2023-04-19 14:47:42', '帮我写出文案介绍,题材为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1648579315978412034, '知乎风格生成器', '生成知乎风格文章', 1645262634249003010, 0, '2023-04-19 14:48:33', '帮我生成知乎风格的文章,关键词为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1648579533197221889, '餐厅点评小助手', '输入关键词,帮你生成餐厅点评', 1645262162100396033, 0, '2023-04-19 14:49:24', '帮我点评餐厅,关键词为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1648579737413689345, '解梦小助手', '请描述你的梦境,帮你做出简单的解析', 1645262162100396033, 0, '2023-04-19 14:50:13', '帮我解梦,我梦到了:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651076216603590657, '数学题', '帮你解答数学题,请输入题目', 1651090130397609985, 0, '2023-04-26 12:10:20', '帮我解答下数学题,题目是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651076474913996801, '医疗咨询小助手', '输入疑难杂症,提出建议', 1645262162100396033, 0, '2023-04-26 12:11:22', '我想咨询医疗方面的问题,问题是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651077212188753922, '法律咨询小助手', '解决各种法律问题,请输入问题', 1645262162100396033, 0, '2023-04-26 12:14:18', '我想咨询法律问题,问题是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651078032540090370, '旅游攻略小助手', '输入目的地制定最佳旅游攻略', 1645262162100396033, 0, '2023-04-26 12:17:33', '帮我做一个旅游攻略,我要去的地方是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651078835703169026, '营销方案小助手', '各种营销方案', 1648578845964705793, 0, '2023-04-26 12:20:45', '帮我写一个营销方案,关键词是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651080998714130434, '朋友圈文案', '填写关键词写出朋友圈文案', 1645262634249003010, 0, '2023-04-26 12:29:20', '帮我写出朋友圈文案,关键词为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651081225609199618, '个性签名小助手 ', '填写关键词生成个性签名', 1645262634249003010, 0, '2023-04-26 12:30:14', '帮我写一个个性签名,关键词是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651081664975126530, '小说生成小助手', '输入文章开头，AI自动续写', 1648578845964705793, 0, '2023-04-26 12:31:59', '写个天龙八部后记小说');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651081911575035905, '论文小助手', '填写学科生成各学科论文', 1648578845964705793, 0, '2023-04-26 12:32:58', '帮我写一篇论文,学科是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651091852272648193, '物理题', '填写问题获得解答', 1651090130397609985, 0, '2023-04-26 13:12:28', '帮我解答物理题,题目是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651091941045092354, '化学题', '填写题目获得答案', 1651090130397609985, 0, '2023-04-26 13:12:49', '帮我解答化学题,题目是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651092291969925122, '写作文', '输入作文题目和要求', 1651090130397609985, 0, '2023-04-26 13:14:13', '帮我写一篇作文,作文题目是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651093342617911297, '周报年报生成器', '输入工作内容,帮你快速完成周报月报年报.', 1645262634249003010, 0, '2023-04-26 13:18:23', '帮我写工作周报月报年报,工作内容是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651093563137638401, '邮件小助手', '描述场景和需求,帮你生成客套话.', 1645262634249003010, 0, '2023-04-26 13:19:16', '帮我写一封邮件,我的场景和需求是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651093928729952258, '女友道歉助手', '输入女朋友生气的原因,帮你生成一段道歉的话.', 1648578719447719938, 0, '2023-04-26 13:20:43', '帮我生成一段给女朋友道歉的话,惹女朋友生气的原因是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651094151854342146, '甩锅小助手', '请输入想要甩锅的事件,帮你生成一段甩锅的话.', 1648578719447719938, 0, '2023-04-26 13:21:36', '帮我生成一段甩锅的话,事情是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651094374781599746, '恋爱话术小助手', '输入关键词,帮你生成土味情话', 1648578719447719938, 0, '2023-04-26 13:22:29', '帮我生成土味情话,关键词是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651096298419437570, '夸夸小助手', '请描述你想夸的人,小助手帮你夸夸', 1648578719447719938, 0, '2023-04-26 13:30:08', '帮我生成夸人的话,那个人是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651096537855475713, '电影评论', '生成电影评论', 1648578845964705793, 0, '2023-04-26 13:31:05', '帮我评论下电影,电影名字是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651097519742042113, '职场开解小树洞', '请输入遇到的职场问题,让小树洞为你排忧解难.', 1645262162100396033, 0, '2023-04-26 13:34:59', '帮我解惑下职场问题,我遇到的问题是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651097782661988353, '节日祝福', '输入节日名称,帮你写一封节日祝福.', 1645262162100396033, 0, '2023-04-26 13:36:02', '帮我写一封节日祝福,节日为:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651098528862224386, '外卖好评生成器', '请输入你点的外卖类型,帮你生成好评内容.', 1645262162100396033, 0, '2023-04-26 13:39:00', '帮我生成外卖好评内容,我点的外卖是:');
INSERT INTO `tb_tmpl_qs` (`id`, `qs_title`, `qs_hint`, `tid`, `status`, `create_time`, `qs_call`) VALUES (1651098857863430145, '歌曲推荐', '输入歌曲风格类型推荐几首好歌', 1645262162100396033, 0, '2023-04-26 13:40:18', '帮我推荐几首好听的歌曲,类型是:');
COMMIT;

-- ----------------------------
-- Table structure for tb_token
-- ----------------------------
DROP TABLE IF EXISTS `tb_token`;
CREATE TABLE `tb_token` (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='用户Token';

-- ----------------------------
-- Records of tb_token
-- ----------------------------


-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户id(主键)',
  `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '手机号',
  `wx_openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '普通用户的标识，对当前开发者帐号唯一',
  `wx_unionId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '用户统一标识。针对一个微信开放平台帐号下的应用，同一用户的unionid是唯一的',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `vip_date` datetime DEFAULT NULL COMMENT 'VIP到期时间',
  `last_login` datetime DEFAULT NULL COMMENT '最后登录时间',
  `status` int DEFAULT NULL COMMENT '0:正常状态 1:封禁状态',
  `lock_reason` varchar(140) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '封禁原因',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '头像地址',
  `ip` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'ip',
  `channel` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '渠道号',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账号(可以为空但是不能重复)',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `pid` bigint DEFAULT NULL COMMENT '上级ID',
  `msg_count` int DEFAULT NULL COMMENT '剩余消息次数',
  `money` decimal(20,2) DEFAULT '0.00' COMMENT '用户可提现余额',
  `levelone_proportion` decimal(20,2) DEFAULT NULL COMMENT '用户下一级返利比例',
  `secondary_proportion` decimal(20,2) DEFAULT NULL COMMENT '用户下二级返利比例',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `wy` (`mobile`,`username`) USING BTREE,
  KEY `sy` (`status`,`nick_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1651119876670005250 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------


-- ----------------------------
-- Table structure for tb_withdrawal
-- ----------------------------
DROP TABLE IF EXISTS `tb_withdrawal`;
CREATE TABLE `tb_withdrawal` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '提现表ID（主键ID）',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提现用户昵称',
  `withdrawal_money` decimal(10,2) NOT NULL COMMENT '提现金额',
  `reality_money` decimal(10,2) DEFAULT NULL COMMENT '实到金额(扣除手续费后金额)',
  `front_vacancies` decimal(10,2) DEFAULT NULL COMMENT '提现前余额',
  `behind_vacancies` decimal(10,2) DEFAULT NULL COMMENT '提现后余额(当前余额)',
  `service_charge` decimal(10,2) DEFAULT NULL COMMENT '提现手续费',
  `service_charge_scale` decimal(10,2) DEFAULT NULL COMMENT '提现手续费比例',
  `make_collections_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户收款二维码链接',
  `type` int DEFAULT NULL COMMENT '收款类型(1:支付宝  2:微信)',
  `status` int DEFAULT NULL COMMENT '审核状态(0:审核中  1:审核通过  2:审核拒绝)',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '审核内容(拒绝填写拒绝理由  成功不用填写)',
  `time` datetime DEFAULT NULL COMMENT '创建时间',
  `examine_time` datetime DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651112931322011651 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户提现表';

-- ----------------------------
-- Records of tb_withdrawal
-- ----------------------------
BEGIN;
INSERT INTO `tb_withdrawal` (`id`, `user_id`, `user_name`, `withdrawal_money`, `reality_money`, `front_vacancies`, `behind_vacancies`, `service_charge`, `service_charge_scale`, `make_collections_url`, `type`, `status`, `content`, `time`, `examine_time`) VALUES (1651109966955716609, 1650837116290097154, '远离的灯红酒绿', 97.00, 97.00, 97.50, 0.50, 0.00, 0.00, 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/7e0c77d389b145baa4348cc9cdd0654e.jpg', 2, 1, '审核通过!', '2023-04-26 14:24:27', '2023-04-26 14:25:05');
INSERT INTO `tb_withdrawal` (`id`, `user_id`, `user_name`, `withdrawal_money`, `reality_money`, `front_vacancies`, `behind_vacancies`, `service_charge`, `service_charge_scale`, `make_collections_url`, `type`, `status`, `content`, `time`, `examine_time`) VALUES (1651112931322011650, 1651111880753717250, '🥇方向哥『小程序暴力变现』', 300.00, 300.00, 319.30, 19.30, 0.00, 0.00, 'https://momoyu-chatgpt.oss-cn-chengdu.aliyuncs.com/20230426/f57b20c670d04f11a0dc67449d10a3ff.jpeg', 2, 1, '审核通过!', '2023-04-26 14:36:14', '2023-04-26 14:37:01');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
